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

112 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
elutes6402031(None) 
elates65032361elates
elites66027121elites
eluates72014671eluates
eludes75417681eludes
elute54822571elute_
eluted74915261eluted
flutes95421781flutes
glutes74517671glutes
lutes55836661_lutes
acutes83917722acutes
alates64833962alates
blites84721212blites
blues75127042blu_es
bluets87215492bluets
blumes105917792blumes
brutes86118682brutes
butes714535872_butes
chutes114615762chutes
clues74623032clu_es
cutes79438312_cutes
delates83526282delates
deletes83117932deletes
deludes91810642deludes
deluges9169262deluges
deputes104911782deputes
dilutes82911962dilutes
educes94011952educes
elate55335882elate_
elated74725822elated
elater64724202elater
elaters74420182elaters
elides74420692elides
elite56230182elite_
elopes85918162elopes
eluate62315432eluate_
elude64517622elude_
eluded84612772eluded
eluder73712212eluder
eluders8409902eluders
elves85118742el_ves
emeutes938012emeutes
emotes84620282emotes
enates64026422enates
enures63919712enures
equates162012312equates
equites162212492equites
etudes73811602etudes
evites94916472evites
evolutes1156062evolutes
exudes143710362exudes
flites95122442flites
flues84626922flu_es
flukes135114192flukes
flumes115119732flumes
flute86823752flute_
fluted104917162fluted
fluter95316862fluter
fluters103713672fluters
flutey125212522flutey
fluxes165212932fluxes
flytes123911562flytes
gelates83219582gelates
glues65125682glu_es
glumes94516812glumes
glute66020902glute_
glutei7409742glutei
gluten74210752gluten
glutens8437592glutens
gluteus8386252gluteus
gluts66120132glut_s
jutes125125132_jutes
kluges11389562kluges
klutzes2064112klutzes
leudes75314092leudes
lubes74727992_lubes
luces75528432_luces
ludes65728852_ludes
lues45943552_lu_es
luges65928752_luges
lunes55337772_lunes
lures56138532_lures
lute46341012_lute_
lutea54819072_lutea
luted64826142_luted
lutzes153711922_lutzes
luxes124921502_luxes
mutes75033782_mutes
pelites93821992pelites
plates85432242plates
plumes104318132plumes
pluses83618072pluses
plutei8408902plutei
pluteus9326242pluteus
refutes104515722refutes
relates73731422relates
relumes9612512relumes
reputes94615962reputes
routes66129312routes
salutes73716252salutes
sautes63924912sautes
scutes85219192scutes
shutes93518212shutes
slates64934062slates
slues54527172slu_es
sluts54523982slut_s
solutes73515262solutes
utes45930882__utes
velites103417302velites
veloutes1136152veloutes
velures1039092velures
volutes102710982volutes

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 Filter178691825510.233766914.2
2DLD Change Limit825511126.59612515.3
3Display Results1121120.0601866.7
 (SQL Overall)1786911126.88925938.6
 
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.