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

264 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
ables7593554(None) 
abbes96723521abbes
abeles84719391abeles
able66340531able_
abled86926831abled
abler75624311abler
ablest84721831ablest
abyes105518531abyes
ales47067101a_les
ambles105121861ambles
arles56735741arles
axles125219471axles
bales76250081bales
cables104527551cables
fables114921671fables
gables94222331gables
sables85026691sables
tables84524891tables
aals49941142aal_s
abas68642082ab_as
abase76023482abase
abases85720772abases
abates85825032abates
abbas95918642abbas
abbe87627192abbe_
abbess10509772abbess
abbey125714932abbey
abbeys13538422abbeys
abed79734132ab_ed
abele76323252abele
abet610547942ab_et
abets75621672abets
abides94719892abides
ablates92416902ablates
ableism1136822ableism
ableist9311772ableist
ablins8316192ablins
ablush1147222ablush
ably99725132abl_y
abodes94417512abodes
abos67734412ab_os
aboves114512842aboves
abris75722602abris
abs59356072ab__s
abuse77119562abuse
abuses85119102abuses
abuts75417072abuts
abye97921002abye_
abys97221882ab_ys
abyss10669462abyss
aces67645092a_ces
aches106132292aches
acmes96020652acmes
acnes75922622acnes
acres76327762acres
addles84216602addles
adzes155913802adzes
aedes64625142aedes
ages55844592a_ges
aglee65728492aglee
aglet65534142aglet
aglets73915682aglets
agley96917332agley
agues64919052agues
aides65336602aides
ailed66240282ailed
ails45654712ail_s
aisles64721142aisles
akees96119242akees
alas46358122a_las
albas75925392albas
albs68628572a_lbs
ale36572342a_le_
alec66430062a_lec
alecs76620732a_lecs
alee46652322a_lee
alef76340692a_lef
alefs87319662a_lefs
allee54932122allee
allees64521482allees
alley85721672alley
alleys95113302alleys
allies63827672allies
alls46740922a_lls
almes75126542almes
alms65834922a_lms
aloes54933672aloes
alps65529242a_lps
als36663022a_l_s
alts46639902a_lts
amble95924642amble_
ambled115116372ambled
ambler104916452ambler
amblers115213562amblers
amies76837692amies
amoles84122192amoles
aneles64626292aneles
anes45255932a_nes
angles74426702angles
ankles104818382ankles
anlas55626932anlas
anoles64827432anoles
antes56334322antes
apes66047432a_pes
apples104315762apples
apres75426402apres
apses76823912apses
arables91814972arables
ares45871022a_res
argles75218482argles
arses55733872arses
ashes86230612ashes
asses55629282asses
ates45047922a_tes
atlas55821582atlas
aures55137092aures
aves76142602a_ves
awes76037552a_wes
awless939262awless
awls75926092awl_s
axels126313632axels
axes117337852a_xes
axle116424602axle_
axled135315812axled
ayes76543512a_yes
azoles154614612azoles
babbles104416322babbles
babels105216722babels
babes95834112babes
babies106123652babies
bakes117035372bakes
balas76937212balas
balds85524642balds
bale66353842bale_
baled85436442baled
baler75635272baler
balers85626932balers
balks114926292balks
balls76236412balls
balms95723922balms
bals66354042bal_s
banes74945582banes
bares75457132bares
bases75644352bases
bates75846342bates
baubles113611862baubles
bees65453382_bees
bels66142492_bels
bes56557432_b_es
bibles104617642bibles
biles75542142biles
bleb85425222_bleb
blebs96416152_blebs
bled75729312_bled
bless75917812_bless
blest76431722_blest
blet66247672_blet
blets75324942_blets
blew94722432_blew
blues75127042_blues
boles75448602boles
byes95230532_byes
cable95329912cable_
cabled114819872cabled
cabler104519172cabler
cablers114416712cablers
cablet104429462cablet
cablets114216342cablets
carles85435082carles
caules85927252caules
cobles104622882cobles
coles76055062coles
dabbles124514772dabbles
dales66439742dales
dalles74222062dalles
deles65139252deles
doles67843752doles
eagles73819162eagles
enables92813122enables
fable105824752fable_
fabled124216382fabled
fabler116115812fabler
fablers124812612fablers
farles96025782farles
files85441272files
gabbles124415412gabbles
gabies93820732gabies
gable85325522gable_
gabled105518452gabled
gales65442482gales
gambles124016202gambles
garbles104016922garbles
gules64831042gules
hales85449842hales
haoles94919802haoles
holes84748652holes
idles66720122idles
isles54220562isles
joles125230832joles
kales95730982kales
kayles134712002kayles
labels84515682labels
ladles74619542ladles
les35663072__les
mabes96331532mab_es
macles107023222macles
mailes84329112mailes
males75049792males
maples104819422maples
marbles114516652marbles
miles74645072miles
moles74747922moles
mules75034292mules
nabes75427092nab_es
nobles83319722nobles
obes66036832ob_es
oboes75717712oboes
oboles83815832oboles
ogles65223182ogles
oles46453472_oles
orles55326212orles
padles95221122padles
pales75753802pales
parles86334402parles
peles75738082peles
piles74742612piles
poles75351002poles
pules74538812pules
rabbles113517972rabbles
rabies85226022rabies
rales54947492rales
rambles113118312rambles
riles55343642riles
robles85321692robles
roles56747982roles
rubles83921702rubles
rules55234252rules
sabes76437462sab_es
sable74732162sable_
sabres85520862sabres
sales56055592sales
soles55547922soles
stables93219072stables
tabes76033922tab_es
tablas83716162tablas
table75429602table_
tabled94020042tabled
tablet84227642tablet
tablets94714382tablets
tales55451372tales
teles54536002teles
tiles55542102tiles
toles55147132toles
tules54532792tules
umbles103817492umbles
vales85434262vales
voles86234042voles
wabbles144013992wabbles
wales86142832wales
wambles143714022wambles
warbles123215562warbles
wiles85437872wiles
wyles114615322wyles
yules84521582yules

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.0931921408.6
2DLD Change Limit538002642.34322962.0
3Display Results2642640.1431846.2
 (SQL Overall)1786912642.57969286.9
 
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.