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

310 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
biner7593069(None) 
bider85728381bider
bier65531841bi_er
biker116022561biker
binder94422871binder
bine66650871bine_
biners85023631biners
bines76946791bines
binger94923451binger
biter75030031biter
boner75133081boner
briner84519041briner
diner65632901diner
finer85431561finer
liner55938921liner
miner76933541miner
abider95314462abider
aider65431142aider
aimer75926822aimer
airer54927892airer
aiver85725162aiver
aliner65621982aliner
bailer85425252bailer
baiter84422562baiter
baker115629542baker
baler75635282baler
bander93928222bander
bane65250432bane_
baned85436352baned
banes74945582banes
banger94423642banger
banker124222732banker
banner84421502banner
banter84825342banter
barer74535802barer
baser74828922baser
beer65635992b_eer
bender95223302bender
bene66439492bene_
benes75536232benes
bibber94613572bibber
bice86235572bice_
bicep115413542bicep
bices95029962bices
bicker144819172bicker
bidder104114862bidder
bide76041512bide_
bided95424972bided
biders94822802biders
bides85536782bides
bidet84935632bidet
biers76225222bi_ers
bigger104315062bigger
bike106532612bike_
biked125320032biked
bikers124517552bikers
bikes117529472bikes
bile66147192bile_
biles75542142biles
bilker124913442bilker
biller84923482biller
bin56658652bin__
binal75323822binal
binary11312222binary
bind76234522bin_d
binders103920742binders
bindery13459832bindery
bindi85617022bindi
binds86627482binds
binge85125512binge
binged105920822binged
bingers104519992bingers
binges93923122binges
bingo86020092bingo
binit76431582binit
binned94414542binned
bins66548262bin_s
bint67355052bin_t
bints76130182bints
biped104718832biped
birder94915492birder
birler85715082birler
birr66022372bi_rr
bise66437112bise_
bises75435622bises
bister84922762bister
bite66547012bite_
biters83925242biters
bites75641172bites
bitter84622672bitter
bize155926302bize_
bizes165923662bizes
blinder103912992blinder
blinker134110212blinker
bluer74918492bluer
boiler84319272boiler
bonder95324782bonder
bone65949322bone_
boned85133242boned
boners84825432boners
bones76446532bones
boney105227312boney
bonier84321992bonier
bonzer175313672bonzer
borer75131272borer
bower107328182bower
boxer145016522boxer
briber104714052briber
brier74527402brier
brine75132272brine_
brined95118412brined
briners94315632briners
brines85028852brines
bringer104213352bringer
brinier93613472brinier
bunker124519372bunker
bunter85020382bunter
burner83819202burner
buyer105013092buyer
byliner1235722byliner
caner75334772caner
cider84723322cider
cinder94119122cinder
cine66242952cine_
cines75239682cines
citer74827332citer
coiner84323782coiner
dicer85426422dicer
diker105524552diker
dimer85625602dimer
dinar66319892dinar
dine55555342dine_
dined76431992dined
dinero75612642dinero
diners75525952diners
dines66449152dines
dinger85323672dinger
dinner74217162dinner
direr64927072direr
diver94827802diver
eider64624752eider
fainer94717242fainer
fiber104921132fiber
fifer115519972fifer
filer85433002filer
finder104020232finder
fine75147962fine_
fined94930502fined
finery124512892finery
fines86644262fines
finger104920332finger
firer811229252firer
fiver116024942fiver
fixer154717832fixer
gainer74117492gainer
giber85417702giber
ginger84920032ginger
ginner73915822ginner
giver94921202giver
goner66025162goner
hider95024092hider
hiker125119392hiker
hinder104120062hinder
hinger104723332hinger
hinter94021302hinter
hirer85423122hirer
honer85332092honer
inert53234372_inert
infer84215032_infer
inker94421092_inker
inner54920632inner
inter55028492_inter
jiber145115702jiber
jinker174013542jinker
jiver155119052jiver
joiner134114132joiner
kier86526822ki_er
kinder113716852kinder
kine85643442kine_
kines95039142kines
kiter95523222kiter
liber74723622liber
lier45942472li_er
lifer85822152lifer
liger65024472liger
liker95627062liker
limner84112872limner
line46965582line_
linear65113342linear
lined64934642lined
linen55728722linen
liners65428852liners
lines57054572lines
liney87029632liney
linger75226002linger
linier64423792linier
linker104321472linker
linter64625342linter
liter54736342liter
liver85132962liver
loner55431042loner
miler75733062miler
mimer94825762mimer
mincer104017362mincer
minder94822502minder
mine67256182mine_
mined85333352mined
miners84126632miners
mines75651952mines
minor74920062minor
minter84425102minter
miser75430402miser
miter75734792miter
mixer145017642mixer
nicer74618292nicer
nine45842182nine_
nines55937342nines
niter55028972niter
oiler54628282oiler
owner84613312owner
pier66035302pi_er
piker115622842piker
pincer104019172pincer
pinder94523462pinder
pine67755722pine_
pined85935322pined
pinery115214292pinery
pines76048862pines
piney105727502piney
pinger94324092pinger
pinier84024692pinier
pinker125322442pinker
pinner84521502pinner
piper96523192piper
ricer74726612ricer
rider65231312rider
rifer84721982rifer
rimer75429242rimer
ringer74526062ringer
rinser64317212rinser
riper74328402riper
riser55431052riser
river85731692river
ruiner64013642ruiner
saner54334322saner
seiner64622482seiner
shiner93820872shiner
signer74015632signer
siker95326032siker
sine46560632sine_
sines55954822sines
sinew84718922sinew
singer74227312singer
sinker103620902sinker
sinner64320602sinner
sinter63625922sinter
siver85728612siver
sizer145521812sizer
tier44936152ti_er
tiger65718632tiger
tiler56131022tiler
timer75626042timer
tinder73821802tinder
tine45855142tine_
tinea54923162tinea
tined65434532tined
tines54848422tines
tinier63622232tinier
tinker103619922tinker
tinner64119962tinner
tinter63923642tinter
titer55430612titer
toner55336242toner
tuner56022682tuner
twiner94012592twiner
vainer93714572vainer
veiner94514752veiner
vier75428162vi_er
viler86324162viler
vine75643692vine_
vined95626152vined
vinery124912602vinery
vines85137642vines
vinier93716742vinier
viper105017302viper
weiner94214132weiner
whiner124516632whiner
wider94826362wider
wiener94513542wiener
wincer115018192wincer
winder104025262winder
wine74953432wine_
wined94434182wined
winery125014282winery
wines85546862wines
winey115325432winey
winger104125442winger
winier94522452winier
winker134220292winker
winner94219932winner
winter94222802winter
wiper105421292wiper
wirer85124952wirer
wiser85522802wiser
wiver115924512wiver
zine137036162zine_
zineb165614142zineb
zines145232652zines
zinger163816702zinger
zoner144520342zoner

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.310576422.6
2DLD Change Limit538003101.65632487.9
3Display Results3103100.0933333.3
 (SQL Overall)1786913102.05986785.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.