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 “birder” 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
birder9491549(None) 
bidder104114861bidder
bider85728371bi_der
binder94422871binder
birded104414301birded
birders103913261birders
birler85715081birler
border94419971border
girder84312061girder
abider95314462abi_der
aider65431132ai_der
airer54927892air_er
airier64619362airier
arider74717742arider
badder103817512badder
balder95318862balder
bander93928222bander
barber104419322barber
barde85330772barde_
barded105426422barded
bardes95026932bardes
barer74535802bar_er
barker124822862barker
barter85525372barter
beader94623792beader
bedder104215792bedder
bender95223302bender
bibber94613572bibber
bicker144819172bicker
bidden104010792bidden
bidders114012312bidders
bide76041482bi_de_
bided95424962bi_ded
biders94822802bi_ders
bides85536772bi_des
bidet84935622bi_det
bier65531832bi__er
bigger104315062bigger
biker116022562bi_ker
bilker124913442bilker
biller84923482biller
binders103920742binders
bindery13459832bindery
biner75930692bi_ner
binger94923452binger
bird76128322bird__
birdie94013782birdie
birdied11329432birdied
birdies104016212birdies
birdmen1235832birdmen
birds85421332bird_s
birle75023632birle_
birled94416992birled
birlers93813002birlers
birles84920642birles
birr66022362bir__r
birred94713202birred
birse74517402birse_
birses84717732birses
bister84922762bister
biter75030032bi_ter
bitter84622672bitter
blader93618582blader
blinder103912982blinder
boarder103910322boarder
bolder94820932bolder
bonder95324782bonder
bordel94514572bordel
borders104317532borders
borer75131272bor_er
briber104714052briber
bride86425532bride_
brides94423512brides
bridler103811072bridler
brier74527402b_rier
briner84519042briner
budder104314812budder
builder1037572builder
burden9412472burden
burger94020792burger
burier84324652burier
burker125221172burker
burler84723832burler
burner83819202burner
burrer83718472burrer
carder94524182carder
cider84723312ci_der
cinder94119122cinder
corder94322882corder
direr64927072dir_er
eider64624742ei_der
finder104020232finder
firer811229252fir_er
firmer114712442firmer
gilder84415532gilder
girded93712492girded
girders9379942girders
girdler9227312girdler
harder105022402harder
herder104516462herder
hider95024082hi_der
hinder104120062hinder
hirer85423122hir_er
kidder123811102kidder
kinder113716842kinder
larder73720972larder
lieder74912322lieder
milder93818452milder
minder94822502minder
mirier83918362mirier
mirker123712692mirker
murder93613782murder
order65019362_order
pinder94523452pinder
ridder84015142ridder
rider65231302ri_der
sirdar7269102sirdar
tinder73821802tinder
tireder837702tireder
warder104020272warder
weirder1144922weirder
widder112913972widder
wider94826352wi_der
wilder103616472wilder
winder104025262winder
wirer85124952wir_er
wirier94215552wirier
yarder103813972yarder

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 Filter178691825510.343520965.0
2DLD Change Limit825511282.53032628.9
3Display Results1281280.0462782.6
 (SQL Overall)1786911282.91961216.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.