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

228 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
valuates11281120(None) 
evaluates12247351evaluates
valuate102512731valuate_
valuated12239201valuated
alates64833972_al_ates
devaluates14266062devaluates
eluates72014682_eluates
evacuates14256802evacuates
evaluate11287792evaluate_
evaluated13276652evaluated
gallates92815532gallates
malates93522612mal_ates
maleates103316342maleates
palates93624942pal_ates
palpates122613062palpates
revaluates13246792revaluates
salutes73716252salu_tes
toluates8138902toluates
vacates12312832va_cates
valerates12310542valerates
validates1338242validates
vallate103016562vallate_
valuables1442972valuables
valuator1196732valuator
valuators1286472valuators
values94314942valu__es
valutas1036532valu_tas
valvate133710812valvate_
variates111214992variates
volutes102710982volu_tes
vulgates12237232vulgates
abates85825043_a_bates
ablates92416913_ablates
actuates10310313actuates
acuate8315633_acuate_
acutes83917723_acu_tes
adulates9311913_adulates
aerates74627503_aerates
agates76121343_a_gates
agnates82813193_agnates
alate55340333_al_ate_
alated75625153_al_ated
albatas938383_albatas
albites9313213_albites
alcades101011473_alcades
aliases7914493_aliases
alkanes113812933_alkanes
alunites8310703_alunites
annates72415423_annates
aviates10313083_aviates
balases93815433bal_ases
balatas9311833bal_atas
baldpates1445233baldpates
ballades114211643ballades
ballutes1037523ballutes
baluster1037053baluster
balusters1136643balusters
calcites12313003calcites
calculates1498703calculates
califates14310113califates
calottes10610083calottes
calumets1236283calumets
canulates11312873canulates
carates95630613ca_rates
caseates10313713caseates
caudates11310263caudates
ciliates10413453ciliates
collates103019143collates
dealates92716683deal_ates
delates83526283del_ates
devaluate13226363devaluate_
devaluated15265493devaluated
dilates83220663dil_ates
dilutes82911973dilu_tes
elates65032363_el_ates
eluate62315433_eluate_
elutes64020313_elu_tes
emulates10312573emulates
equates162012323_equates
evacuate13217303evacuate_
evacuated15196263evacuated
evaluator12104963evaluator
evaluators1374593evaluators
evolutes1156063evolu_tes
fabulates1447733fabulates
falcate12311623falcate_
falcated1438483falcated
fellates11312753fellates
filiates11412663filiates
flutes95421783_flu_tes
folates103218453fol_ates
foliates11412753foliates
galatea839973gal_atea
galateas937153gal_ateas
galaxes1538883gal_axes
galeate83916793galeate_
galeated104111583galeated
galettes93111163galettes
gallate83417133gallate_
gelates83219593gel_ates
glutes74517673_glu_tes
graduates1147683graduates
halites103221193hal_ites
hamates122917683ha_mates
haulages1236623haulages
jaculates182810363jaculates
kalifates1646133kalifates
karates115617473ka_rates
labiates101011523labiates
lactates10311233lactates
liquates1737453liquates
lutes55836663__lu_tes
luxates1436973__luxates
maculates132013723maculates
magnates11511613magnates
malate84624563mal_ate_
maleate94117543maleate_
maltases1039693maltases
mandates11314093mandates
maturates11311763maturates
narrates8312763narrates
oblates91913243obl_ates
oleates7417833_oleates
ovulates1148523ovul_ates
oxalates1557063oxal_ates
palaces114216463pal_aces
palate84226793pal_ate_
paleate94120003paleate_
palettes103112833palettes
palliates11311043palliates
palmate113215233palmate_
palmated132511003palmated
palpate113213923palpate_
palpated13249763palpated
placates12311763placates
plates85432243_pl_ates
pulsates1048813pulsates
radiates92415303radiates
reevaluates1453013reevaluates
relates73731443rel_ates
revaluate12277103revaluate_
revaluated14306363revaluated
salivates1239293salivates
salute64418023salu_te_
saluted84511713salu_ted
saluter73512453salu_ter
saluters8319863salu_ters
salvages1238123salvages
satiates8314633satiates
saturates9811603saturates
sautes63924913sa_u_tes
savates10312953sa_vates
sinuates8310963sinuates
situates8310373situates
slates64934063_sl_ates
solates73523853sol_ates
solutes73515263solu_tes
solvates11249673solvates
sulfates11310793sulfates
tabulates1139143tabulates
tailgates1046533tailgates
tallages92312003tallages
taluses7311213talu_ses
tannates81911953tannates
toluate7159343toluate_
ululates848433_ululates
vacate11314553va_cate_
vacated1349353va_cated
vacillates1555723vacillates
vacuities1447143vacuities
vacuoles1345013vacuoles
valances1398763valances
valences1388513valences
valerate11311473valerate_
vales85434263val___es
valeted1139013val_eted
valets93715623val_et_s
valguses1234233valguses
valiances1487203valiances
valiants1137793valiants
validate1239003validate_
validated1446493validated
valines104520213val_ines
valises103516273val_ises
valses94514613val__ses
valuable1336863valuable
valuably1644713valuably
valuating1338653valuating
valuation1249973valuation
valuations1348783valuations
value85719093valu__e_
valued104011153valu__ed
valueless1242843valueless
valuer93911443valu__er
valuers10328943valu_ers
valuta938743valu_t_a
valves124113783val__ves
valvules1443473valvules
vanadates1345133vanadates
vantages12119023vantages
variate101316433variate_
variated121211393variated
varuses10310623varu_ses
vaulted11307193va_ulted
vaulter10257713va_ulter
vaulters11206173va_ulters
vaults94511673va_ult_s
vaunted11438863va_unted
vaunter10309603va_unter
vaunters11327753va_unters
vaunts95212623va_unt_s
velate93720143vel_ate_
velites103417303vel_ites
veloutes1136153veloutes
velures1039093velu_res
vibrates132210623vibrates
villages123010603villages
violates11311193violates
virgates1237923virgates
vitiates112311433vitiates
voltages1237253voltages
voltes94915583vol__tes
volumes12298233volu_mes
volute93912763volu_te_
voluted11297943volu_ted
volvate13317993volvate_
vulgate11388433vulgate_
vulvate13388323vulvate_

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.436409841.7
2DLD Change Limit1461622287.15620425.1
3Display Results2282280.0932451.6
 (SQL Overall)1786912287.68523251.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.