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

165 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
abler7562431(None) 
able66340531able_
abled86926831abled
ables75935541ables
ambler104916451ambler
baler75635271baler
cabler104519171cabler
fabler116115811fabler
abaser86414342abaser
abater85518122abater
abbe87627192abbe_
abbes96723522abbes
abbey125714932abbey
abed79734132ab_ed
abele76323252abele
abeles84719392abeles
abet610547942ab_et
abhor10411062abhor
abider95314462abider
ablest84721832ablest
ably99725132abl_y
abuser85413682abuser
abye97921002abye_
abyes105518532abyes
adder75419592adder
after85719792after
ager55935842a_ger
agger76420892agger
aglee65728492aglee
aglet65534142aglet
agley96917332agley
aider65431132aider
ailed66240282ailed
aimer75926822aimer
airer54927892airer
aiver85725162aiver
alar46340072a_lar
alder65421912alder
ale36572342a_le_
alec66430062a_lec
alee46652322a_lee
alef76340692a_lef
alert54740652a_lert
ales47067102a_les
allee54932122allee
alley85721672alley
alter54828502alter
ambeer104511602ambeer
amber94523212amber
amble95924642amble_
ambled115116372ambled
amblers115213562amblers
ambles105121862ambles
ameer75618982ameer
ampler104313302ampler
anger66225882anger
angler74017862angler
antler64615552antler
aper66336232a_per
apter76120202apter
arles56735742arles
armer76924442armer
ashler9459972ashler
asker96418782asker
asper75520432asper
aster55434892aster
auger64922472auger
aulder7511452aulder
aver75931882a_ver
axle116424602axle_
axled135315812axled
axles125219472axles
babbler104012822babbler
babier103515572babier
bailer85425252bailer
baker115629542baker
balder95318862balder
bale66353842bale_
baled85436442baled
balers85626932balers
bales76250082bales
balker124519162balker
baller83825202baller
barer74535802barer
baser74828922baser
bawler114315052bawler
beer65635992_beer
bier65531832_bier
blear75918682_blear
bleb85425222_bleb
bled75729312_bled
blet66247672_blet
blew94722432_blew
bluer74918492_bluer
blur66020532_blur
caber95126832cab_er
cable95329912cable_
cabled114819872cabled
cablers114416712cablers
cables104527552cables
cablet104429462cablet
caller85125482caller
dabber114816962dabber
dabbler124012152dabbler
enabler9299362enabler
fabber134814112fabber
fable105824752fable_
fabled124216382fabled
fablers124812612fablers
fables114921672fables
faller94621232faller
filer85433002filer
gabber114916602gabber
gabbler124013302gabbler
gable85325522gable_
gabled105518452gabled
gables94222332gables
gambler123612682gambler
gaoler73913572gaoler
garbler104012562garbler
hailer94720342hailer
haler85033522haler
hauler95015122hauler
idler65015662idler
iller54821292iller
jabber173713642jabber
jailer134316682jailer
labeler92310182labeler
ladler74314932ladler
mailer84724182mailer
marbler113511672marbler
mauler84416712mauler
miler75733062miler
nabber104913542nabber
nailer64119362nailer
nobler83713452nobler
ogler65917442ogler
oiler54628282oiler
paler75436932paler
poler74431792poler
puler74826622puler
rabbler113514092rabbler
railer64524932railer
rambler113313262rambler
ruler54923342ruler
saber75330242sab_er
sable74732162sable_
sables85026692sables
sailer63526102sailer
stabler94014932stabler
taber73825822tab_er
table75429602table_
tabled94020042tabled
tables84524892tables
tablet84227642tablet
tailer63823732tailer
taler56034862taler
taller63721962taller
tiler56131022tiler
viler86324162viler
wabbler143511922wabbler
wailer93720322wailer
waler84229262waler
warbler123211462warbler
yabber136111832yabber

Search took 9 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 Filter178691538001.483120492.9
2DLD Change Limit538001656.4568333.3
3Display Results1651650.0901833.3
 (SQL Overall)1786911658.02922255.7
 
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.