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 “iterates” 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.

294 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
iterates8131782(None) 
iterate71119111iterate_
iterated91213821iterated
literates91415651literates
aerates74627492_aerates
aliterates101510752aliterates
berates94126872_berates
cerates95428252_cerates
citrates102315092cit_rates
derates84028892_derates
ideates8313732ide_ates
ingrates9514172ingrates
integrates111010782integrates
iterances1148902iterances
itinerates10126132itinerates
liberates111012942liberates
literate81216892literate_
literatus9146822literatus
nitrates82516222nit_rates
operates10515412operates
reiterates10412002reiterates
stearates939452stearates
titrates82314662titrates
acerate92818913acerate_
acerated113113983acerated
acerbates1347263acerbates
acetates102013063acetates
acierates11310813acierates
aerate64830553_aerate_
aerated85322373_aerated
agemates111110023agemates
aliterate91611333aliterate_
alliterates11106253alliterates
altercates1247553altercates
alternates1047873alternates
ameerates1149063ameerates
amirates101114793amirates
antedates1048613antedates
asperates11312553asperates
attrites8311563attrites
averages1249183averages
berakes134815773_berakes
berate84729023_berate_
berated104422133_berated
birthrates1545023birthrates
biteplates1444153biteplates
borates94823013_borates
butyrates1446083butyrates
carates95630613_carates
catenates11311813catenates
cerastes101111093_cerastes
cerate84829463_cerate_
cerated103922473_cerated
cerites94823433_cerites
certes84623083_cer_tes
chelates132713843chelates
citrate92216803cit_rate_
citrated112712253cit_rated
crates85736063__crates
creates95225203cre_ates
cremates124216003cremates
curates95323833_curates
deaerates10313643deaerates
debates103718533_debates
delates83526283_delates
derate74531233_derate_
derated93623503_derated
derats74625063_derat_s
deuterates1149083deuterates
disrates91118153disrates
elates65032363__elates
elevates111110423elevates
emeerates1149373emeerates
emirates101214853emirates
enates64026423__enates
enervates1248723enervates
erases64425403__erases
ergates8314493__ergates
esterases949633esterases
execrates1839563execrates
federates13310153federates
ferrates113013423ferrates
filtrates1247733filtrates
gelates83219583_gelates
generates10312713generates
gheraoes1244813gheraoes
grates75429893__grates
gyrates113610263_gyrates
hibernates1544623hibernates
hydrates15229413hydrates
icteruses1144973icteruses
ideate7313683ide_ate_
ideated9310973ide_ated
illiterates11115653illiterates
imamates1237663imamates
imbrutes1244203imbrutes
imitates10310503imitates
impetrates1445453impetrates
indurates10310693indurates
inearths1144933inearths
inebriates1246063inebriates
inerts64517023iner_t_s
inflates11512193inflates
ingates82716913i_ngates
ingrate8715123ingrate_
inmates92715783i_nmates
innervates1346383innervates
instates81615833instates
integrate10911153integrate_
integrated1289293integrated
intenerates1148083intenerates
interacted13411213interacted
interacts11312123interacts
interage9314483interage_
interfaces15410403interfaces
interlaces12412043interlaces
intermats111412453intermat_s
internees93014843internees
internes82721233inter_nes
interstates11710203interstates
interties9320333interties
intervales131010503intervales
intestates10159433intestates
intimates111013313intimates
intonates9410243intonates
intreated10312663intreated
intreats8311543intreat_s
intubates1147123intubates
iodates8312903i_odates
irades74517393i__rades
irate55627983i__rate_
irater65218353i__rater
iratest7312483i__ratest
isolates8613513isolates
itemises1087693itemises
itemizes19106023itemizes
iterance1049513iterance
iterant7317783itera_nt
iterating10314253iterating
iteration9515033iteration
iterations10413823iterations
iterative12410713iterative
itinerate9116253itinerate_
itinerated11124933itinerated
karates115617473_karates
lacerates112413773lacerates
laterites9715053laterites
legates82917683_legates
liberate101113383liberate_
liberated1299473liberated
librates103412953librates
literacies1248803literacies
literals8312293litera_ls
literately1345303literately
literati81210803literat_i
literatim11127183literatim
literator948683literator
literators1048103literators
literatures1183653literatures
litigates1048003litigates
littermates1352863littermates
macerates132113573macerates
maturates11311763maturates
metates92720013_metates
meterages1248183meterages
micturates1456093micturates
migrates111112853migrates
misrates101318243misrates
mitigates1248253mitigates
moderates12710753moderates
narrates8312763narrates
negates83215843_negates
niteries8318383niter_ies
nitrate72017013nit_rate_
nitrated92213153nit_rated
nitrites82313453nit_rites
numerates11199573numerates
obliterates1345123obliterates
obturates1157003obturates
oleates7417833ole_ates
operate9615733operate_
operated11512223operated
orates64328613__orates
outrates82421373outrates
overages12513833overages
overate10620963overate_
overawes14511183overawes
overhates15311943overhates
overrates12414623overrates
peerages1189893peerages
penates93321593_penates
petrales10312983petrales
phenates13611573phenates
phorates13413043phorates
picrates122013213picrates
pirates93020333_pirates
prates84633163__prates
predates11615813predates
prelates10418573prelates
prorates10418073prorates
rates55352013___rates
rebates95123183_rebates
recrates102420373recrates
redates83423873_redates
regrates92618403regrates
reiterate9412933reiterate_
reiterated11410153reiterated
relates73731433_relates
remates93827113_remates
retraces101417273retraces
saturates9811603saturates
sedates83418033_sedates
senates73322583_senates
serapes95218103_serapes
seriates82620673_seriates
serrates82617023serrates
siderites10410433siderites
situates8310373sit_uates
states64337083st__ates
stearate839723stearate_
steerages1046493steerages
steres63929533ster__es
sterlets8169273sterlets
sternites9310073sternites
stomates10313343stomates
storages9311103storages
storaxes1536883storaxes
strafes104516003st_rafes
strakes114218073st_rakes
stratas73013583st_ratas
straths102711723st_raths
stratus73011733st_ratus
striates83417083striates
styraxes1833493styraxes
tates55444983_t__ates
teases65426273_te_ases
teated74924023_te_ated
teats55636813_te_at_s
tenaces92814513_tenaces
terabytes1443333_terabytes
terais64023513_tera_is
teratism10312173_teratism
terces83921413_ter_ces
tercets93512443_tercets
terete6319333_terete_
tergites9310543_tergites
termites10313693_termites
ternate7415483_ternate_
ternes65422903_ter_nes
terraces102712253_terraces
terranes82514433_terranes
terrases82111483_terrases
terrets72913583_terrets
terries73425633_terries
testates83615453_testates
testes65125823_te_stes
texases1437573_texases
thraves13469713_thraves
tierces93710453tier_ces
tirades8311723_tirades
titanates976093titanates
titivates1246433titivates
titrate72215573titrate_
titrated92611683titrated
tolerates9312123tolerates
tortes64826053_tor_tes
traces85329933_t_races
trades75724503_t_rades
trapes85024463_t_rapes
traves94222743_t_raves
treated83618703_treated
treater74219833_treater
treaters83615843_treaters
treaties8316983_treaties
treats64821693_treat_s
triturates1046763triturates
ulcerates1148853ulcerates
uncrates10314563uncrates
uprates93814863_uprates
urates65027763__urates
uteruses837183uteruses
valerates12310543valerates
venerates12312263venerates
verites103822263_verites
verstes104014283_verstes
vibrates132210613vibrates
vicarates1487623vicarates
vitiates112311433vit_iates
vituperates1652393vituperates
vizierates2243243vizierates
vizirates2144663vizirates
waterages1349383waterages
witherites1645973witherites
yperites13310153yperites

Search took 9 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.203880251.2
2DLD Change Limit1461622947.79618748.3
3Display Results2942940.1262333.3
 (SQL Overall)1786912948.12521992.7
 
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.