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

270 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
valuate10251273(None) 
evaluate11287791evaluate
vallate103016561vallate
valuated12239201valuated
valuates112811201valuates
valvate133710811valvate
acuate8315632_acuate
alate55340332_al_ate
devaluate13226362devaluate
eluate62315432_eluate
evacuate13217302evacuate
evaluated13276652evaluated
evaluates12247352evaluates
falcate12311622falcate
galeate83916792galeate
gallate83417132gallate
malate84624562mal_ate
maleate94117542maleate
palate84226792pal_ate
paleate94120002paleate
palmate113215232palmate
palpate113213922palpate
revaluate12277102revaluate
salute64418022salu_te
toluate7159342toluate
vacate11314552va_cate
valerate11311472valerate
validate1239002validate
valuable1336862valuable
valuator1196732valuator
value85719092valu__e
valuta938742valu_ta
valutas1036532valutas
variate101316432variate
velate93720142vel_ate
volute93912762volu_te
volvate13317992volvate
vulgate11388432vulgate
vulvate13388322vulvate
abate76627843_a_bate
ablate82219213_ablate
actuate9311443actuate
acute74720363_acu_te
adnate72913483_adnate
adulate8313233_adulate
aerate64830553_aerate
agate66525153_a_gate
agnate73314883_agnate
alae45643753_al_a_e
alane56135613_al_ane
alated75625153_al_ated
alates64833973_al_ates
albata839333_albata
albite8313313_albite
alcade91111513_alcade
algae65319623_alga_e
alkane104313323_alkane
alulae6312743_alulae
alunite7311633_alunite
ansate64517863_ansate
aquae142212713_aqua_e
arcuate9311963arcuate
aurate64426473_aurate
aviate9315203_aviate
baccate131011263baccate
balata8614683bal_ata
baldpate1345483baldpate
ballade104012563ballade
ballute938543ballute
baluster1037053baluster
barbate11314543barbate
blate75933783_bl_ate
bullate93415073bullate
calceate1239863calceate
calcite11413783calcite
calculate1389873calculate
califate13310483califate
calotte9510563calotte
calumet11313293calumet
calycate1537893calycate
canulate10314553canulate
carate84734003ca_rate
caseate9314783caseate
caudate10311353caudate
ciliate9514603ciliate
clavate1238713clavate
collate92919683collate
dealate83617843deal_ate
delate73827753del_ate
devaluated15265493devaluated
devaluates14266063devaluates
dilate73220693dil_ate
dilute72911803dilu_te
elate55335883_el_ate
eluates72014683_eluates
elute54822573_elu_te
emulate9314123emulate
equate152012463_equate
evacuated15196263evacuated
evacuates14256803evacuates
evaluable1444233evaluable
evaluative1644233evaluative
evaluator12104963evaluator
evolute1045683evolu_te
fabulate1339203fabulate
falcated1438483falcated
fellate10313433fellate
filiate10414233filiate
flute86823753_flu_te
folate93320393fol_ate
foliate10513533foliate
galatea839973gal_atea
galeae74717453galea_e
galeated104111583galeated
galette84212703galette
gallates92815533gallates
gelate73421263gel_ate
glute66020903_glu_te
graduate1058083graduate
halite93624233hal_ite
halutz1868853halu_tz
hamate113319833ha_mate
hamulate1359013hamulate
hastate10313913hastate
haulage1136913haulage
haute89521613ha_u_te
jaculate172311783jaculate
kalifate1556493kalifate
karate105320923ka_rate
labiate91313573labiate
lactate9312703lactate
lacunate10128963lacunate
lanate6421263la_nate
late47560483__l_ate
liquate1638423liquate
lunate6316043__lunate
lute46341013__lu_te
luxate1338083__luxate
maculate122815623maculate
magnate10512703magnate
malates93522613mal_ates
maleates103316343maleates
maltase938903maltase
mammate104411273mammate
mandate10315573mandate
maturate10312623maturate
narrate7313493narrate
oblate82214743obl_ate
oleate6318883_oleate
ovulate1039453ovul_ate
oxalate1457623oxal_ate
palace104516923pal_ace
palates93624943pal_ates
paleae84820293palea_e
palette93613983palette
palliate10311893palliate
palmated132511003palmated
palpated13249763palpated
palpates122613063palpates
peltate92013773peltate
pileate93815923pileate
placate11312433placate
planate9314573planate
plate74635113_pl_ate
plumate1149803_plumate
pulsate9510233pulsate
quate144521413__quate
radiate83416313radiate
ramate83921693ra_mate
reevaluate1353143reevaluate
relate64033633rel_ate
revaluated14306363revaluated
revaluates13246793revaluates
saccate111311763saccate
salivate11310013salivate
salpae84614273salpa_e
saluted84511713salu_ted
saluter73512453salu_ter
salutes73716253salu_tes
salvage1138193salvage
satiate7315403satiate
saturate8312813saturate
saute55028083sa_u_te
savate9313783sa_vate
sinuate7412163sinuate
situate7410783situate
slate55438283_sl_ate
solate64526073sol_ate
solute64016663solu_te
solvate102710213solvate
sulcate9314423sulcate
sulfate10311653sulfate
tabulate10310893tabulate
tailgate946823tailgate
tallage82712073tallage
tannate71813523tannate
toluates8138903toluates
ululate749963_ululate
vacated1349353va_cated
vacates12312833va_cates
vacillate1456853vacillate
vacua10510463vacua__
vacuity1545763vacuity
vacuolate1445223vacuolate
vacuole1245373vacuole
vaginate123911083vaginate
vague96513113vagu__e
valance1269253valance
vale74937343val___e
valence1268773valence
valerates12310543valerates
valet84337873val_et_
valeted1139013val_eted
valets93715623val_ets
valiance1397383valiance
valiant10314623valiant
valiants1137793valiants
validated1446493validated
validates1338243validates
valine94623093val_ine
valise92917643val_ise
valse85117523val__se
valuables1442973valuables
valuably1644713valuably
valuating1338653valuating
valuation1249973valuation
valuators1286473valuators
valued104011153valu_ed
valuer93911443valu_er
valuers10328943valuers
values94314943valu_es
valuing11298843valuing
valval12398863valva_l
valvar12388653valva_r
valve114515933val__ve
valvulae1442723valvulae
valvule1343663valvule
vanadate1245513vanadate
vantage11109893vantage
variated121211393variated
variates111214983variates
vault85823763va_ult_
vaulted11307193va_ulted
vaulter10257713va_ulter
vaults94511673va_ults
vaulty12388443va_ulty
vaunt85925313va_unt_
vaunted11438863va_unted
vaunter10309603va_unter
vauntie1036633va_untie
vaunts95212623va_unts
vaunty12409063va_unty
veloute1037733veloute
velure939773velu_re
vibrate122811523vibrate
villae95615383villa_e
village113610833village
violate10311553violate
virgate1138733virgate
vitiate103412953vitiate
vittate10409733vittate
volante1038513volante
voltage1136863voltage
volte85321303vol__te
voluble1244503voluble
volume11358273volu_me
voluted11297943volu_ted
volutes102710983volu_tes
vulgates12237233vulgates
vulvae12438033vulva_e

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340272705.93622578.7
3Display Results2702700.0932903.2
 (SQL Overall)1786912706.43527768.6
 
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.