Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “uncinate” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

108 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
uncinate1031239(None) 
runcinate1146471runcinate
lancinate1147802lancinate
succinate1346682succinate
unciae83215312unci_a_e
uncinal959962uncina_l
uncrate9415952unc_rate
uncreate10311352uncreate
unornate848012unornate
urinate7315362u_rinate
agminate1139243agminate
alginate9310693alginate
animate91617213an_imate
binate8419773__binate
carinate103320243carinate
circinate1347813circinate
culminate1347813culminate
decimate13411123decimate
dominate11312853dominate
echinate1359403echinate
enceinte1046263encein_te
encina8310443encina__
encinal949243encina_l
encinas938723encina_s
encrinite1146043encrinite
enunciate1145743enunci_ate
fascinate1447763fascinate
fulminate1446553fulminate
geminate11411803geminate
incarnate1157223incarnate
inchoate1347673inchoate
incinerate1246463incinerate
incite83618733inci__te
increate10312203increate
incubate1238663incubate
incudate1138873incudate
indicate11313353indicate
infinite1149593infinite
innate63917313in__nate
insinuate945963insinuate
intimate101013833intimate
intonate8310923intonate
iodinate949343iodinate
laciniate1156843laciniate
lacunate10128963lacunate
laminate103014633laminate
lancinated1345573lancinated
lancinates1247153lancinates
machinate1647953machinate
marinate103017783marinate
neonate7311333_neonate
nictate9310223_nictate
nidate7313783_n_idate
nominate10312473nominate
nucleate1048673nucleate
ordinate9310253ordinate
paginate114012443paginate
patinate103016313patinate
pectinate1349553pectinate
pulvinate1445193pulvinate
punctate1246473punc_tate
punctuate1343743punctuate
quinate16511573_quinate
reclinate11410023reclinate
resinate8316773resinate
ruinate7312833_ruinate
ruminate10511473ruminate
spinate93114813_spinate
succinates1445633succinates
supinate10310313supinate
tunicate103310043tun_icate
turbinate1146673turbinate
ulcerate1039733ulcerate
ultimate1049203ultimate
umbonate1245293umbonate
uncage93014873unc__age
uncake122813523unc__ake
uncase83817433unc__ase
unchaste1346923unchaste
uncia75015163unci_a__
uncial83715223unci_a_l
uncials92510523unci_als
unciliated1348053unciliated
uncinaria11154423uncinaria
uncini8310153uncin__i
uncinus937403uncin_us
uncoated11314963unc_oated
uncrated11416313unc_rated
uncrates10314563unc_rates
uncreated12312303uncreated
uncreates11310433uncreates
uncute82912133unc__ute
underate9918603underate
undine7817263undin__e
undulate9310403undulate
ungulate939803ungulate
unhinge11237283unhin_ge
uniface1236953un_iface
unitage838993un_itage
unite54828383un_i__te
unmingle1145913unmingle
unstate71916213un_state
urinated9311613u_rinated
urinates8314133u_rinates
urticate1049863urticate
vaccinate1646833vaccinate
vaginate123911083vaginate
vicinage1444003vicinage

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.406440125.6
2DLD Change Limit1461621087.29620033.2
3Display Results1081080.0462347.8
 (SQL Overall)1786911087.74823062.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.