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

118 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
validates133824(None) 
validate1239001validate_
validated1446491validated
alidades1037002_alidades
califates14310112califates
invalidates1554062invalidates
kalifates1646132kalifates
lapidates1247142lapidates
revalidates1554362revalidates
salivates1239292salivates
valerates12310542valerates
validities1447302validities
valuates112811202val_uates
vanadates1345132vanadates
variates111214982vari_ates
agitates9310883_agitates
airdates939723_airdates
alates64833973_al__ates
alginates10310123_alginates
aliases7914493_ali_ases
alidade936993_alidade_
alidads936293_alida_ds
alienates9310683_alienates
amidases1136653_amidases
amirates101114793_amirates
animates101316423_animates
aviates10313073_avi_ates
backdates1848153backdates
baldpates1445233baldpates
calibrates1446963calibrates
califate13310483califate_
caliphates1745133caliphates
candidates1446303candidates
caudates11310263ca_udates
cavitates14168963cavitates
celibates1358633celibates
ciliates10413453cili_ates
climates12311973_climates
delicates12314313delicates
evaginates1475993evaginates
evaluates12247353eval_uates
filiates11412663fili_ates
foliates11412753foli_ates
gallates92815533gal_lates
halides113416663halid__es
halidomes15104863halidomes
halites103221193hali__tes
invalidate1444423invalidate_
invalidated1653613invalidated
kalifate1556493kalifate_
kaliphates1943033kaliphates
khalifates2042153khalifates
labiates101011513labi_ates
laminates112712903laminates
lapidate1157903lapidate_
lapidated1345673lapidated
ligates82318383__ligates
malates93522613mal__ates
maleates103316343mal_eates
mandates11314093ma_ndates
marinates112516393marinates
militates11310883militates
navigates1345873navigates
nidates8311893__nidates
obligates12207853obligates
oxidates1636333_oxidates
paginates123111373paginates
palates93624943pal__ates
palisades1245613palisades
palliates11311033palliates
palmitates1445453palmitates
palpates122613063pal_pates
palpitates1445303palpitates
patinates113814703patinates
playdates1554903playdates
radiates92415293radi_ates
radicates12412073radicates
revalidate1454703revalidate_
revalidated1654223revalidated
salivate11310013salivate_
salivated1337473salivated
sanitates9611733sanitates
satiates8314633sati_ates
silicates11311523silicates
tailgates1046533tailgates
vacates12312833va__cates
vaccinates1746563vaccinates
vacillates1555723vacillates
vaginate123911083vaginate_
vaginated14328153vaginated
valerate11311473valerate_
valiances1487203valiances
valiants1137793vali_ants
validating1545843validating
validation1448413validation
validations1547243validations
validity1545993validit_y
validness13125363validness
valines104520213vali__nes
valises103516263vali__ses
vallate103016563val_late_
valuate102512733val_uate_
valuated12239203val_uated
valvate133710813val_vate_
vanadate1245513vanadate_
vanadiates1443743vanadiates
vapidities1646383vapidities
variate101316433vari_ate_
variated121211393vari_ated
variegates1444043variegates
variolates1347463variolates
velites103417303veli__tes
vellicates1545903vellicates
veritates12310973veritates
vesicates14119033vesicates
vitiates112311433viti_ates
vizirates2144663vizirates
vulgates12237233vul_gates

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411187.25020502.2
3Display Results1181180.0462565.2
 (SQL Overall)1786911187.70223200.6
 
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.