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

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

95 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
delta6611777(None) 
delt57855271delt_
deltas74414821deltas
delts65731791delts
belga8313232belga
belt65754032belt_
belts75931162belts
beta66234132be_ta
betta74916842betta
cella75420312cella
celt65646712celt_
celts75325782celts
cesta75419482cesta
data56026652d_ata
dealt65234282dealt_
death94822522death
debt77139022debt_
debts86418372debts
deet57356582deet_
deets65330242deets
defat95426692defat
deflea1037442deflea
deft85540222deft_
deity94316772deity
del46752752del__
delate73827752delate
delay94820632delay
dele56843082del_e
delead84112342delead
deled75326542deled
deles65139252deles
delete73620702delete
delf85436572del_f
delfs94918672delfs
delft95623322delft
delfts10439672delfts
deli55631292del_i
delis64928542delis
dell56938202del_l
dells66630942dells
delly96023872delly
dels56745472del_s
deltaic1037022deltaic
deltic9312502deltic
delve96018262delve
dent57158412dent_
dental74319172dental
dents65031802dents
depth114311852depth
derat65044082derat
derma84918512derma
deva85720982de_va
dicta84915632dicta
dita56032522d_ita
dolma86214172dolma
dolt56649422dolt_
dolts65626312dolts
dulia61014982dulia
dwelt94316522dwelt_
eta35834192_e_ta
fella84918652fella
felt75146932felt_
felts85324542felts
feta76528902fe_ta
gelt56448012gelt_
gelts65924612gelts
geta56627442ge_ta
kelt85343192kelt_
kelts95222632kelts
lepta75714392lepta
melt65752892melt_
melts74930102melts
melty104918362melty
menta74424422menta
meta65932412me_ta
pelota8612832pelota
pelt67651082pelt_
pelts76128812pelts
reata54225392reata
recta74220262recta
selva83014272selva
septa75518082septa
seta45637312se_ta
shelta93111782shelta
tecta74215522tecta
tela45532972tel_a
telia55821142telia
testa54822042testa
vela75725542vel_a
vesta86618302vesta
volta85215622volta
welt75547862welt_
welts85225192welts
yenta83917042yenta
zeta135121642ze_ta

Search took 4 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 Filter178691538000.0931921408.6
2DLD Change Limit53800953.32616175.6
3Display Results95950.0631507.9
 (SQL Overall)178691953.48251318.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.