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

109 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
babier10351557(None) 
babied114913511babied
babies106123651babies
abider95314462_abider
abler75624312_abler
babbler104012822babbler
babe86835822bab_e_
babel95821692bab_el
babes95834112bab_es
babiest114414752babiest
backer144525532backer
badder103817512badder
badger105415082badger
bagger104619202bagger
baggier113611642baggier
bailer85425252bailer
baiter84422562baiter
baker115629542ba_ker
balder95318862balder
baler75635272ba_ler
balker124519162balker
balkier134111982balkier
baller83825202baller
balmier113811512balmier
bander93928222bander
banger94423642banger
banker124222732banker
banner84421502banner
banter84825342banter
barber104419322barber
barbie105018352barbie_
barbies114519592barbies
barer74535802ba_rer
barker124822862barker
barkier133814482barkier
barmier114313042barmier
barnier93213672barnier
barrier94017752barrier
barter85525382barter
baser74828922ba_ser
basher115123812basher
baster85333602baster
bather115322512bather
batter84928882batter
battier93515722battier
bawdier13378202bawdier
bawler114315052bawler
beadier103513912beadier
beakier134012162beakier
beamier113411942beamier
belier84423562belier
bibber94613572bibber
bier65531832__bier
blabber10418922blabber
bobber95016742bobber
bonier84321992bonier
boxier154311742boxier
brakier133812362brakier
brasier94516752brasier
brazier183911472brazier
briber104714052briber
brier74527402b_rier
burier84324652burier
busier85219722busier
caber95126832cab_er
cabler104519172cabler
cagier93715932cagier
cahier113615772cahier
cakier123115242cakier
dabber114816962dabber
daubier1037102daubier
easier64218462easier
fabber134814112fabber
fabler116115812fabler
gabber114916602gabber
gabbier12379632gabbier
gabies93820732gabies
gambier124711972gambier
gamier93617932gamier
hazier184712402hazier
jabber173713642jabber
lacier84020092lacier
lakier104716272lakier
lambier113611642lambier
lazier154214612lazier
matier84321522matier
mazier175013062mazier
nabber104913542nabber
oakier104011392oakier
orbier839992orbier
pacier105018682pacier
palier85023562palier
panier84425502panier
rabies85226022rabies
racier85120972racier
rapier84019992rapier
ribier84414232ribier
rubier84814742rubier
saber75330242sab_er
sabir75917002sabi_r
sagier73717162sagier
taber73825822tab_er
varier94619352varier
wanier93920682wanier
warier93722892warier
wavier124613082wavier
waxier16439902waxier
yabber136111832yabber
zanier154314712zanier

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.356501941.0
2DLD Change Limit825511092.39334496.9
3Display Results1091090.0462369.6
 (SQL Overall)1786911092.79563932.4
 
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.