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

233 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
slier5482724(None) 
flier86023401flier
lier45942461_lier
plier75221281plier
shier85428941shier
skier95119591skier
slicer84117601slicer
slider73918361slider
sliver94116591sliver
slyer85515121slyer
spier75728031spier
alder65421912alder
alien56425582alien
aliner65621982aliner
alter54828502alter
ashier94714832ashier
belier84423562belier
bier65531832_bier
bluer74918492bluer
brier74527402brier
crier74724462crier
drier64423962drier
eelier64216462eelier
elder64020022elder
elmier839812elmier
elver85216242elver
filer85433002filer
fleer86020772fleer
flied96519432flied
fliers94417192fliers
flies85630712flies
flir76422202fli_r
flyer114916252flyer
frier85225842frier
glider84614262glider
gluer65116772gluer
gluier7310262gluier
holier94921622holier
icier74313752icier
iller54821292iller
inlier63615362inlier
kier86526812_kier
leer46239352_leer
liar47229682_liar
liber74723622_liber
lie38264522_lie_
lied55838092_lied
lief76036992_lief
lien45339802_lien
liers55130402_liers
lies46454192_lies
lieu46534362_lieu
lifer85822152_lifer
liger65024472_liger
liker95627062_liker
liner55938922_liner
lire47845292_lire
liter54736342_liter
liver85132962_liver
miler75733062miler
oiler54628282oiler
oilier64417232oilier
older65121172older
osier53518012osier
palier85023562palier
pier66035292_pier
plie65127392plie_
plied85118592plied
pliers84715152pliers
plies74526512plies
plyer106214332plyer
prier75027762prier
relier65826182relier
rulier65016352rulier
saber75330242saber
safer84721812safer
sager65432052sager
sagier73717162sagier
sailer63526102sailer
saker95132022saker
sallier73320422sallier
salter64325082salter
saltier74318632saltier
salver94617752salver
saner54334322saner
saver84831252saver
sawer85026212sawer
sayer84926552sayer
scalier94316912scalier
seder64826762seder
seer45547042s_eer
seiner64622482seiner
seiser65318342seiser
seizer154114572seizer
seller63824602seller
ser36752402s__er
serer55935512serer
sever85426052sever
sewer84426222sewer
sexier13310682sexier
shalier103116422shalier
sheer84726892sheer
shied96125492shied
shiel811023772shiel
shiers94921752shiers
shies86136552shies
shiner93820872shiner
shire84727132shire
shirr84716922shirr
shiver124517372shiver
shoer84722162shoer
shyer114714782shyer
sieur5911892s_ieur
siker95326032siker
silex123417412silex
silkier114411642silkier
siller64026062siller
sillier74017592sillier
siltier73413862siltier
silver93815812silver
sir35746672s_i_r
sire46150412s_ire
siver85728612siver
sizer145521812sizer
sizier1514813392sizier
skied104417752skied
skiers104713702skiers
skies95026832skies
skiey125012892skiey
skirr94810542skirr
skiver134612102skiver
slaker104219272slaker
slater64429182slater
slatier74016812slatier
slaver94419612slaver
slayer93916332slayer
sled55334372sl_ed
sleek94619042sleek
sleep74920182sleep
sleet55639132sleet
slew76228232sl_ew
slice74925822slice
sliced94416312sliced
slicers94114922slicers
slices84022852slices
slick115520522slick
slicker133314532slicker
slid55828982sli_d
slide64725412slide
sliders83515222sliders
slides73922182slides
sliest66621962sliest
slieve9359272slieve
slily85820032slily
slim66631962sli_m
slime74925752slime
slimed94915122slimed
slimes84722042slimes
slimier93212012slimier
slimmer114211342slimmer
slims75423652slims
slimy105417422slimy
sling66028802sling
slinger83413832slinger
slink95422912slink
slip67031732sli_p
slipe75626132slipe
sliped95417062sliped
slipes84921412slipes
slipper113712982slipper
slips76023722slips
slipt76627482slipt
slit46250102sli_t
slither104112982slither
slits56128852slits
slitter73615872slitter
slivers104115252slivers
sloe45534952sloe_
sloes54728872sloes
sloper84615912sloper
slower94016152slower
slue45332192slue_
slued64220512slued
slues54527172slues
slur45525152sl_ur
smiler83916682smiler
smiter83616412smiter
sneer54919952sneer
snider74413912snider
sniper84413642sniper
sober74822412sober
solder73921342solder
soldier82812152soldier
solider82912452solider
solver94016702solver
sorer56236592sorer
sower85229312sower
speer74623902speer
speir75315362speir
spicer104719312spicer
spider94516802spider
spied85427712spied
spiel74623912spiel
spiers84421742spiers
spies76037622spies
spiker124315662spiker
spire75828692spire
splicer114710522splicer
sprier84119062sprier
steer55423862steer
stied65723032stied
sties55132982sties
stir45723252sti_r
stiver93915732stiver
suber74924502suber
suer45334032s_uer
suiter64121812suiter
sulker104015922sulker
sulkier113811962sulkier
super74924482super
surer54833102surer
surlier72915442surlier
sweer84918572sweer
tier44936142_tier
tiler56131022tiler
trier54328532trier
twier84713292twier
uglier748952uglier
ulcer7310752ulcer
vier75428152_vier
viler86324162viler
wilier93217072wilier
wrier84521752wrier

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.343520965.0
2DLD Change Limit538002331.50035866.7
3Display Results2332330.0633698.4
 (SQL Overall)1786912331.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.