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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

142 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
dykes13521557(None) 
dekes105224451dekes
dikes105831331dikes
dukes105023471dukes
dyes85331891dy_es
dyke126418181dyke_
dyked145310951dyked
dykey16608671dykey
dynes95917581dynes
fykes156312691fykes
rykes125513031rykes
sykes124816861sykes
tykes125817061tykes
ayes76543512ay_es
bakes117035372bakes
bikes117529472bikes
byes95230532by_es
byres104421382byres
bytes105217492bytes
cakes116037672cakes
cokes115537192cokes
cukes115422092cukes
cymes1210118922cymes
daces85030682daces
daks97130602dak_s
dales66439742dales
dames85435852dames
dares66146702dares
dates65639152dates
dazes155024142dazes
dees56356632d_ees
deke95228762deke_
deked115718532deked
deles65139252deles
demes86032692demes
denes65639722denes
dexes135224512dexes
dices86434242dices
dies55653522d_ies
dike95935762dike_
diked115024682diked
diker105524552diker
dikers114418792dikers
dikey135116422dikey
dimes85833042dimes
dines66449152dines
dites66339152dites
dives95832402dives
does56554472d_oes
doges75630162doges
doles67843752doles
domes85735562domes
dopes84935042dopes
doses65938502doses
dotes65836692dotes
doves94728152doves
dozes155226302dozes
drakes114715862drakes
drees65628522drees
dreks105714742dreks
dries64733672dries
duces86327472duces
dudes75424372dudes
dues56045502d_ues
duke95628102duke_
duked115218462duked
dunes65332172dunes
dupes86425932dupes
dures65635922dures
dyads10549972dyads
dye75334842dy_e_
dyed96720762dy_ed
dyer85522112dy_er
dyers96617132dyers
dyne85320932dyne_
dynel9569852dynel
dynels10536812dynels
ekes86726602_ekes
eyes75837882ey_es
eyres84921772eyres
fakes126032482fakes
fyces139813642fyces
fyke145915292fyke_
gybes115012722gybes
gyres94820322gyres
gyves125711552gyves
hakes126034302hakes
hikes125426982hikes
hokes126231642hokes
hypes135818672hypes
jakes165023642jakes
jokes165423332jokes
jukes165319102jukes
kikes85122552kikes
kyes115124932ky_es
kytes125012912kytes
lakes95737652lakes
likes96231902likes
lyes75530832ly_es
lyres85019962lyres
lyses84518252lyses
makes115336852makes
mikes115129892mikes
mokes114631032mokes
nukes95418122nukes
odyles10348562odyles
okes84936342_okes
oyes74940132oy_es
pekes114623562pekes
pikes115031032pikes
pokes116133012pokes
pukes114523022pukes
pyes95528992py_es
pyres105523882pyres
pyxes175911402pyxes
rakes94440352rakes
ryes75529352ry_es
ryke115616402ryke_
ryked13669512ryked
sakes95540752sakes
sikes96236082sikes
sokes95031422sokes
syces106416462syces
syke115420562syke_
takes94437792takes
tikes95628902tikes
tokes95234972tokes
tyees86019452tyees
tyes76433372ty_es
tyke115720502tyke_
tynes85920302tynes
types105721062types
tyres84725232tyres
ukes86122812_ukes
wakes126633652wakes
wyes105727502wy_es
wyles114615322wyles
wytes114113432wytes
yes66250612_y_es
yikes125117752yikes
yokes125223022yokes
zymes1924712942zymes

Search took 3 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.1061685764.2
2DLD Change Limit538001422.33023090.1
3Display Results1421420.0304733.3
 (SQL Overall)1786911422.46672461.9
 
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.