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 “lapidate” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
lapidate115790(None) 
lapidated1345671lapidated
lapidates1247141lapidates
capitate121712182capitate
dilapidate1452742dilapidate
labiate91313572labi_ate
laminate103014632laminate
lapidary1454092lapidary
lepidote1144682lepidote
validate1239002validate
agitate8312063_agitate
airdate8311323_airdate
alginate9310693alginate
alidade936993_alidade
amidase1036733_amidase
amirate91115953_amirate
animate91617213_animate
aspirate1039943aspirate
aviate9315203_avi_ate
backdate1748223backdate
califate13310483califate
candidate1356663candidate
capitated14159043capitated
captivate1645923captivate
carinate103320253carinate
caudate10311353ca_udate
cavitate13159833cavitate
cuspidate1443573cuspidate
depilate11311703depilate
dilapidated1652283dilapidated
dilapidates1552613dilapidates
elucidate1265423elucidate
epidote1037393_epidote
epilate9314283_epilate
expiate16910593expi_ate
glaciate1168083glaci_ate
gladiate1057053gladi_ate
kalifate1556493kalifate
labiated11109303labi_ated
labiates101011513labi_ates
lacerate102214713lacerate
laciniate1156843laciniate
lactate9312703la_ctate
lacunate10128963lacunate
lamiae84817453lami_a_e
laminae93512973lamina_e
laminated122610283laminated
laminates112712903laminates
lanate6421263la__nate
lancinate1147803lancinate
lapidaries1345073lapidaries
lapidating1445243lapidating
lapides103012043lapid_es
lapidify1742803lapidify
lapidist1147843lapidist
lapidists1244913lapidists
lariat6629043lari_at_
lariated91212063lari_ated
lariats7615053lari_ats
laureate888023laureate
lepidotes1244303lepidotes
levigate1246623levigate
levirate1147623levirate
levitate1137933levitate
ligate72519253l__igate
lipide93511063lipid__e
liquidate1943763liquidate
litigate948303litigate
loricate10310663loricate
mandate10315573ma_ndate
marinate103017783marinate
navigate1246073navigate
nidate7313783__nidate
opiate8513463_opi_ate
oppilate1245863oppilate
oxidate1537023_oxidate
paginate114012443paginate
palpitate1365973palpitate
papillate13127573papillate
patinate103016313patinate
pedate93117763__pedate
pirate82322883__pirate
playdate1465263pla_ydate
radiate83416313radi_ate
radicate11412873radicate
rapidity1446273rapidity
salivate11310013salivate
sanitate8612043sanitate
sapidity1446433sapidity
satiate7315403sati_ate
spicate113214193_spicate
spinate93114813_spinate
supinate10310313supinate
update93810293_up_date
vaginate123911083vaginate
validated1446493validated
validates1338243validates
vanadate1245513vanadate
vapidity1745193vapidity
variate101316433vari_ate

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.423422437.4
2DLD Change Limit1461621007.22020244.0
3Display Results1001000.0432325.6
 (SQL Overall)1786911007.68623248.9
 
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.