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

131 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
validate123900(None) 
validated1446491validated
validates1338241validates
alidade936992_alidade
califate13310482califate
invalidate1444422invalidate
kalifate1556492kalifate
lapidate1157902lapidate
revalidate1454702revalidate
salivate11310012salivate
vaginate123911082vaginate
valerate11311472valerate
validity1545992validity
vallate103016562val_late
valuate102512732val_uate
valvate133710812val_vate
vanadate1245512vanadate
variate101316432vari_ate
agitate8312063_agitate
airdate8311323_airdate
alate55340333_al__ate
alginate9310693_alginate
alidad838883_alida_d
alidades1037003_alidades
alidads936293_alidads
alienate8311553_alienate
amidase1036733_amidase
amirate91115953_amirate
animate91617213_animate
aviate9315203_avi_ate
backdate1748223backdate
baldpate1345483baldpate
calceate1239863calceate
calibrate1347743calibrate
califates14310113califates
caliphate1645293caliphate
calycate1537893calycate
candidate1356663candidate
capitate121712183capitate
carinate103320253carinate
caudate10311353ca_udate
cavitate13159833cavitate
celibate1259313celibate
ciliate9514603cili_ate
climate11312833_climate
delicate11315493delicate
evaginate1376483evaginate
evaluate11287793eval_uate
falcate12311623fal_cate
filiate10414233fili_ate
foliate10513533foli_ate
galeate83916793gal_eate
gallate83417133gal_late
gladiate1057053gladiate
halide103417993halid__e
halidome14115313halidome
halite93624233hali__te
invalidated1653613invalidated
invalidates1554063invalidates
kalifates1646133kalifates
kaliphate1843253kaliphate
khalifate1942383khalifate
labiate91313573labi_ate
laminate103014633laminate
lapidated1345673lapidated
lapidates1247143lapidates
ligate72519253__ligate
malate84624563mal__ate
maleate94117543mal_eate
mandate10315573ma_ndate
marinate103017783marinate
militate10311673militate
navigate1246073navigate
nidate7313783__nidate
obligate11198303obligate
oxidate1537023_oxidate
paginate114012443paginate
palate84226793pal__ate
paleate94120003pal_eate
palisade1145833palisade
palliate10311893palliate
palmate113215233pal_mate
palmitate1346413palmitate
palpate113213923pal_pate
palpitate1365973palpitate
patinate103016313patinate
playdate1465263playdate
plicate11314513_plicate
radiate83416313radi_ate
radicate11412873radicate
revalidated1654223revalidated
revalidates1554363revalidates
salivated1337473salivated
salivates1239293salivates
sanitate8612043sanitate
satiate7315403sati_ate
silicate10312623silicate
tailgate946823tailgate
vacate11314553va__cate
vaccinate1646833vaccinate
vacillate1456853vacillate
vaginae11377683vagina_e
vaginated14328153vaginated
valerates12310543valerates
valiance1397383valiance
valiant10314623vali_ant
valiants1137793valiants
valid94618393valid___
validating1545843validating
validation1448413validation
validities1447303validities
validly1435573valid_ly
valine94623093vali__ne
valise92917643vali__se
valuated12239203val_uated
valuates112811203val_uates
vanadates1345133vanadates
vanadiate1344443vanadiate
vapidity1745193vapidity
variated121211393vari_ated
variates111214983vari_ates
variegate1344103variegate
variolate1248553variolate
velate93720143vel__ate
vellicate1446433vellicate
vesicate131210053vesicate
vitiate103412953viti_ate
vizirate2045353vizirate
volvate13317993vol_vate
vulgate11388433vul_gate
vulvate13388323vul_vate

Search took 10 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.826216332.9
2DLD Change Limit1461621318.43617326.0
3Display Results1311310.0502620.0
 (SQL Overall)1786911319.31219189.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.