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

231 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
toluate715934(None) 
toluates8138901toluates
collate92919682collate
eluate62315432_eluate
folate93320392fol_ate
foliate10513532foliate
oleate6318882_oleate
solate64526072sol_ate
solute64016662solu_te
solvate102710212solvate
toccate1138772toccate
togate74515682to_gate
tolane64316582tol_ane
tolerate8312322tolerate
tollage82610162tollage
tollgate946252tollgate
toluene736462toluene
toluide835262toluide
toluole736112toluole
torquate1745002torquate
valuate102512732valuate
volute93912762volu_te
volvate13317992volvate
ablate82219213abl_ate
actuate9311443actuate
acuate8315633_acuate
adulate8313233adulate
alate55340333_al_ate
arcuate9311963arcuate
blate75933783_bl_ate
bolete8519613bol_ete
borate85026153bo_rate
bullate93415073bullate
cholate122114933chol_ate
ciliate9514603ciliate
coequate1946153coequate
cognate10312203cognate
collage102813763collage
collated113615063collated
collates103019143collates
colocate12313443colocate
colure8314163colu_re
comate104124843co_mate
connate9315753connate
copulate122614113copulate
cordate10315223cordate
costate94019273costate
delate73827753del_ate
dilate73220693dil_ate
dilute72911803dilu_te
donate73619503do_nate
elate55335883_el_ate
eluates72014683_eluates
elute54822573_elu_te
emulate9314123emulate
equate152012463_equate
etiolate849523etiol_ate
evaluate11287793evaluate
evolute1045683evolu_te
falcate12311623falcate
fellate10313433fellate
filiate10414233filiate
flute86823753_flu_te
folates103218453fol_ates
foliage1147533foliage
foliated1249913foliated
foliates11412753foliates
formate123115093formate
fossate10388603fossate
foveate1338363foveate
galeate83916793galeate
gallate83417133gallate
gelate73421263gel_ate
globate1057823globate
glute66020903_glu_te
goliath1145933goliath
iodate7313503io_date
iolite63221983iol_ite
isolate7313923isol_ate
late47560483__l_ate
liquate1638423liquate
lobate82915243lo_bate
lobulate1078833lobulate
locate83919843lo_cate
loculate101011403loculate
loquat1558283loquat_
loquats1645273loquats
lunate6316043__lunate
lute46341013__lu_te
luxate1338083__luxate
malate84624563mal_ate
maleate94117543maleate
modulate1138593modulate
moulage1037903moulage
notate63217863no_tate
oblate82214743_oblate
oleates7417833_oleates
oolite63319603ool_ite
opiate8513463_opiate
orate55133303_o_rate
ornate6315143_ornate
outate62923403_outate
ovate84214393_o_vate
ovulate1039453_ovulate
palate84226793pal_ate
paleate94120003paleate
palmate113215233palmate
palpate113213923palpate
peltate92013773peltate
pileate93815923pileate
plate74635113_pl_ate
plumate1149803_plumate
poleaxe1656303poleaxe
polite83625073pol_ite
pollute937383pollute
populate122812093populate
prolate9419793prol_ate
pulsate9510233pulsate
quate144521413__quate
relate64033633rel_ate
roseate7613453roseate
rosulate8310903rosulate
rotate63320343ro_tate
roulade857003roulade
route55132073ro_u_te
salute64418023salu_te
sinuate7412163sinuate
situate7410783situate
slate55438283_sl_ate
solace83415823sol_ace
solated83618023sol_ated
solates73523853sol_ates
soluble966103soluble
solutes73515263solu_tes
solvated12237443solvated
solvates11249673solvates
sorbate9311733sorbate
soulmate1047193soulmate
spoliate1039243spoliate
stellate8310503stellate
stolonate944833stolonate
stomate9313123sto_mate
stylate10179773styl_ate
sulcate9314423sulcate
sulfate10311653sulfate
tabulate10310893tabulate
tailgate946823tailgate
tallage82712073tallage
tannate71813523tannate
tate44748603t___ate
telae54323293tel_a_e
ternate7415483ternate
testate73916233testate
thecate123210023thecate
tillage83111343tillage
tillite7313563tillite
titrate72215573titrate
toccata1144943toccata
toeplate1047613toeplate
tofutti1041573tofutti
togae67020113to_ga_e
togated94410663to_gated
togue64816303togu__e
toilette846683toilette
tola45236333tol_a__
tolan55124013tol_a_n
tolanes74216313tol_anes
tolans64319273tol_ans
tolar55524113tol_a_r
tolars64817943tol_ars
tolas54532773tol_a_s
tole46052903tol___e
tolerated1049123tolerated
tolerates9312123tolerates
tollages92410193tollages
tollgates1046053tollgates
tolu45529153tolu___
toluenes836763toluenes
toluic837693tolu_ic
toluid738213tolu_id
toluides935553toluides
toluids835323toluids
toluol636903tolu_ol
toluoles835513toluoles
toluols735823toluols
tolus55024483tolu__s
toluyl933443tolu_yl
toluyls1032833toluyls
tomato8313453to_mato
tomcat101013453tomcat_
tomcats11127773tomcats
tonette7310373tonette
tonnage8168053tonnage
toque145113093toqu__e
toquet154414683toquet_
toquets16367863toquets
torsade837593torsade
torte55431703to__rte
torulae758553torulae
tote46643673to___te
touche114916173to_uche
toupee8316133to_upee
touse55430673to_u_se
tousle64514653to_usle
tout46753823to_u_t_
touted74419743to_u_ted
touter63821033to_u_ter
touts54830393to_u_ts
touzle15429003to_uzle
towage1039833to_wage
towpath1544043towpath
tubate82813173t_ubate
tubulate1038273tubulate
ululate749963_ululate
vallate103016563vallate
valuated12239203valuated
valuates112811203valuates
valvate133710813valvate
velate93720143vel_ate
violate10311553viol_ate
volante1038513volante
voltage1136863voltage
volte85321303vol__te
voluble1244503voluble
volume11358273volu_me
voluted11297943volu_ted
volutes102710983volu_tes
vulgate11388433vulgate
vulvate13388323vulvate
zonate154114923zo_nate
zouave1833573zo_uave

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272317.45317983.0
3Display Results2312310.0763039.5
 (SQL Overall)1786912317.93522519.3
 
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.