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

133 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
fykes15631269(None) 
dykes135215571dykes
fakes126032481fakes
fyces139813641fyces
fyke145915291fyke_
rykes125513031rykes
sykes124816861sykes
tykes125817061tykes
ayes76543512ay_es
bakes117035372bakes
bikes117529472bikes
byes95230532by_es
byres104421382byres
bytes105217492bytes
cakes116037672cakes
cokes115537192cokes
cukes115422092cukes
cymes1210118922cymes
dekes105224452dekes
dikes105831332dikes
dukes105023472dukes
dyes85331892dy_es
dyke126418182dyke_
dyked145310952dyked
dykey16608672dykey
dynes95917582dynes
ekes86726602_ekes
eyes75837882ey_es
eyres84921772eyres
faces106439432faces
fades94932862fades
fake115534942fake_
faked135225482faked
faker124824592faker
fakers134219532fakers
fakey155515422fakey
fames105735922fames
fanes84639892fanes
fares85852872fares
fates85139232fates
faves115331422faves
faxes155726652faxes
fazes175527212fazes
feces105625362feces
fees76450602f_ees
femes105626222femes
feres86038182feres
fes66551672f__es
fetes85630142fetes
fezes175220022fezes
fices106031162fices
fifes114822392fifes
files85441272files
fines86644262fines
fires85740752fires
fives116027362fives
fixes154723592fixes
flakes134118872flakes
flees85828752flees
flies85630712flies
floes85528142floes
flues84626922flues
flukes135114192flukes
flytes123911562flytes
foes76543442f_oes
fores85847102fores
foxes156321092foxes
frees86131392frees
fries85535602fries
froes86126692froes
fumes105224702fumes
fuses85628422fuses
fuzes175120222fuzes
fyce126316832fyce_
fyttes1236932fyttes
gybes115012722gybes
gyres94820322gyres
gyves125711552gyves
hakes126034302hakes
hikes125426982hikes
hokes126231642hokes
hypes135818672hypes
jakes165023642jakes
jokes165423332jokes
jukes165319102jukes
kikes85122552kikes
kyes115124932ky_es
kytes125012912kytes
lakes95737652lakes
likes96231902likes
lyes75530832ly_es
lyres85019962lyres
lyses84518252lyses
makes115336852makes
mikes115129892mikes
mokes114631032mokes
nukes95418122nukes
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 2 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.313570897.8
2DLD Change Limit538001331.56034487.2
3Display Results1331330.0334030.3
 (SQL Overall)1786911331.90693751.8
 
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.