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

128 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
slyer8551512(None) 
flyer114916251flyer
plyer106214331plyer
sayer84926551sayer
shyer114714781shyer
slayer93916331slayer
slier54827241slier
alder65421912alder
alter54828502alter
bluer74918492bluer
buyer105013092buyer
coyer105222842coyer
dryer95111462dryer
dyer85522112_dyer
elder64020022elder
elver85216242elver
eyer76127282_eyer
feyer115014522feyer
flayer124713562flayer
fleer86020772fleer
flier86023402flier
flyers125712802flyers
foyer116416552foyer
fryer115913432fryer
gayer94519192gayer
gluer65116772gluer
hayer114620242hayer
iller54821292iller
layer84626472layer
leer46239352_leer
lier45942462_lier
lye66533412_lye_
lyes75530832_lyes
lyre75623792_lyre
older65121172older
oyer75927652_oyer
payer105125722payer
player115215212player
plier75221282plier
plyers114912982plyers
pryer104415312pryer
saber75330242saber
safer84721812safer
sager65432052sager
saker95132022saker
salter64325082salter
salver94617752salver
saner54334322saner
saver84831252saver
sawer85026212sawer
sawyer12438042sawyer
sayed96127142sayed
sayers94221592sayers
seder64826762seder
seer45547042s_eer
seller63824602seller
ser36752402s__er
serer55935512serer
sever85426052sever
sewer84426222sewer
sheer84726892sheer
shier85428942shier
shoer84722162shoer
shyers124712202shyers
siker95326032siker
siller64026062siller
silver93815812silver
siver85728612siver
sizer145521812sizer
skier95119592skier
skyed13529922skyed
skyey15537222skyey
slaker104219272slaker
slater64429182slater
slaver94419612slaver
slayed104716222slayed
slayers104513322slayers
sled55334372sl_ed
sleek94619042sleek
sleep74920182sleep
sleet55639132sleet
slew76228232sl_ew
slicer84117602slicer
slider73918362slider
sliver94116592sliver
sloe45534952sloe_
sloes54728872sloes
sloper84615912sloper
slower94016152slower
slue45332192slue_
slued64220512slued
slues54527172slues
slur45525152sl_ur
sly66228562sly__
slyest93811362slyest
slyly11489532slyly
slype105112362slype
slypes114410482slypes
sneer54919952sneer
snye77115492snye_
snyes85012752snyes
sober74822412sober
solder73921342solder
solver94016702solver
sorer56236592sorer
sower85229312sower
speer74623902speer
spier75728032spier
spryer11418532spryer
stayer94516482stayer
steer55423862steer
stye76218972stye_
styed95815482styed
styes86316522styes
styler94013302styler
suber74924502suber
suer45334032s_uer
sulker104015922sulker
super74924482super
surer54833102surer
swayer125210972swayer
sweer84918572sweer
toyer84521552toyer
tuyer85414292tuyer
twyer11558522twyer
tyer75323392_tyer
ulcer7310752ulcer
wryer11489302wryer

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.313570897.8
2DLD Change Limit538001281.65632487.9
3Display Results1281280.0304266.7
 (SQL Overall)1786911281.99989390.2
 
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.