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

331 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
diner6563290(None) 
biner75930691biner
dicer85426421dicer
diker105524551diker
dimer85625601dimer
dinar66319891dinar
dine55555331dine_
dined76431991dined
dinero75612641dinero
diners75525951diners
dines66449151dines
dinger85323671dinger
dinner74217161dinner
direr64927071direr
diver94827801diver
finer85431561finer
liner55938921liner
miner76933541miner
aider65431132aider
aimer75926822aimer
airer54927892airer
aiver85725162aiver
aliner65621982aliner
bider85728372bider
bier65531832bi_er
biker116022562biker
binder94422872binder
bine66650862bine_
biners85023632biners
bines76946792bines
binger94923452binger
biter75030032biter
boner75133082boner
briner84519042briner
caner75334772caner
cider84723312cider
cinder94119122cinder
cine66242942cine_
cines75239682cines
citer74827332citer
coiner84323782coiner
daiker115113032daiker
damner95213432damner
dancer94817612dancer
dander811222992dander
danger83722822danger
danker114319662danker
darer65230792darer
darner74017302darner
dater65332312dater
deer56739022d_eer
defer94619752defer
definer114413772definer
deicer94114412deicer
denar65223292denar
dene56643412dene_
denes65639722denes
denier74420692denier
denser74115192denser
deter65028042deter
dialer74315432dialer
diaper94513112diaper
dibber114614712dibber
dice75841892dice_
diced95824682diced
dicers94720742dicers
dices86434242dices
dicey114819332dicey
dicier94416232dicier
dicker134521402dicker
die46759652di_e_
died66137852di_ed
diel59034602di_el
diene65720132diene
dienes75719902dienes
dies55653522di_es
diet57357532di_et
dieter73516772dieter
differ133910842differ
digger94616082digger
dike95935762dike_
diked115024682diked
dikers114418792dikers
dikes105831332dikes
dikey135116422dikey
dime76237642dime_
dimers94321092dimers
dimes85833042dimes
dimmer114112612dimmer
din46459462din__
dinars75417562dinars
dineric10310972dineric
dineros83812332dineros
ding66940952din_g
dinge75627302dinge
dinged95221782dinged
dingers94321382dingers
dinges83825422dinges
dingey114914052dingey
dingier93513672dingier
dingo74720792dingo
dings76331402dings
dingy105721262dingy
dink97137802din_k
dinked124818352dinked
dinkey144812762dinkey
dinkier123411502dinkier
dinks105927952dinks
dinky135819372dinky
dinned84317612dinned
dinners83915442dinners
dino56036752din_o
dinos65428062dinos
dins56652042din_s
dint56759052din_t
dinted84419842dinted
dints67431312dints
dipnet91317472dipnet
dipper114017792dipper
dire56644142dire_
diseur738842diseur
dite55547552dite_
dites66339152dites
dither104417682dither
dive85634772dive_
dived106321372dived
divers105024962divers
divert103922812divert
dives95832402dives
diviner11369882diviner
dizen155214932dizen
doer57734702d_oer
done55747912done_
donee66931012donee
donor64418192donor
doper86128392doper
doser66228562doser
doter65428622doter
dower95027702dower
downer104414922downer
dozer158419272dozer
drainer83012842drainer
drier64423962drier
drinker12349482drinker
driver104714492driver
droner74717672droner
dryer95111462dryer
duiker114110592duiker
dune56137582dune_
dunes65332172dunes
dunker113616462dunker
dunner73913822dunner
duper85519002duper
dwine95616142dwine_
dwined114610212dwined
dwines105013102dwines
dyer85522112d_yer
dyne85320932dyne_
dynel9569852dynel
dynes95917582dynes
eider64624742eider
fainer94717242fainer
fiber104921132fiber
fifer115519972fifer
filer85433002filer
finder104020232finder
fine75147952fine_
fined94930502fined
finery124512892finery
fines86644262fines
finger104920332finger
firer811229252firer
fiver116024942fiver
fixer154717832fixer
gainer74117492gainer
giber85417702giber
ginger84920032ginger
ginner73915822ginner
giver94921202giver
goner66025162goner
hider95024082hider
hiker125119392hiker
hinder104120062hinder
hinger104723332hinger
hinter94021302hinter
hirer85423122hirer
honer85332092honer
idler65015662idler
inert53234372_inert
infer84215032_infer
inker94421092_inker
inner54920632inner
inter55028492_inter
jiber145115702jiber
jinker174013542jinker
jiver155119052jiver
joiner134114132joiner
kier86526802ki_er
kinder113716842kinder
kine85643422kine_
kines95039132kines
kiter95523212kiter
liber74723622liber
lier45942462li_er
lifer85822152lifer
liger65024472liger
liker95627062liker
limner84112872limner
line46965572line_
linear65113342linear
lined64934642lined
linen55728722linen
liners65428852liners
lines57054572lines
liney87029632liney
linger75226002linger
linier64423792linier
linker104321472linker
linter64625342linter
liter54736342liter
liver85132962liver
loner55431042loner
miler75733062miler
mimer94825762mimer
mincer104017362mincer
minder94822502minder
mine67256172mine_
mined85333352mined
miners84126632miners
mines75651952mines
minor74920062minor
minter84425102minter
miser75430402miser
miter75734792miter
mixer145017642mixer
nicer74618292nicer
nine45842172nine_
nines55937342nines
niter55028972niter
oiler54628282oiler
owner84613312owner
pier66035292pi_er
piker115622842piker
pincer104019172pincer
pinder94523452pinder
pine67755712pine_
pined85935322pined
pinery115214292pinery
pines76048862pines
piney105727502piney
pinger94324092pinger
pinier84024692pinier
pinker125322442pinker
pinner84521502pinner
piper96523192piper
ricer74726612ricer
rider65231302rider
rifer84721982rifer
rimer75429242rimer
ringer74526062ringer
rinser64317212rinser
riper74328402riper
riser55431052riser
river85731692river
ruiner64013642ruiner
saner54334322saner
seiner64622482seiner
shiner93820872shiner
signer74015632signer
siker95326032siker
sine46560622sine_
sines55954822sines
sinew84718922sinew
singer74227312singer
sinker103620902sinker
sinner64320602sinner
sinter63625922sinter
siver85728612siver
sizer145521812sizer
tier44936142ti_er
tiger65718632tiger
tiler56131022tiler
timer75626042timer
tinder73821802tinder
tine45855132tine_
tinea54923162tinea
tined65434532tined
tines54848422tines
tinier63622232tinier
tinker103619922tinker
tinner64119962tinner
tinter63923642tinter
titer55430612titer
toner55336242toner
tuner56022682tuner
twiner94012592twiner
vainer93714572vainer
veiner94514752veiner
vier75428152vi_er
viler86324162viler
vine75643682vine_
vined95626152vined
vinery124912602vinery
vines85137642vines
vinier93716742vinier
viper105017302viper
weiner94214132weiner
whiner124516632whiner
wider94826352wider
wiener94513542wiener
wincer115018192wincer
winder104025262winder
wine74953422wine_
wined94434182wined
winery125014282winery
wines85546862wines
winey115325432winey
winger104125442winger
winier94522452winier
winker134220292winker
winner94219932winner
winter94222802winter
wiper105421292wiper
wirer85124952wirer
wiser85522802wiser
wiver115924512wiver
zine137036152zine_
zineb165614142zineb
zines145232652zines
zinger163816702zinger
zoner144520342zoner

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 Limit538003311.54634799.5
3Display Results3313310.0933559.1
 (SQL Overall)1786913311.95291542.5
 
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.