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

161 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
axle11642460(None) 
able66340531able
ale36572341a_le
axe108239491ax_e
axel115222071axel
axile126020511axile
axled135315811axled
axles125219471axles
aal39058672aal_
aals49941142aals
abbe87627192abbe
abele76323252abele
abled86926832abled
abler75624312abler
ables75935542ables
ably99725132ably
abye97921002abye
ace59656832a_ce
ache96829822ache
acme86924322acme
acne66625872acne
acre67330772acre
addle74318352addle
adze1412820572adze
ae212590292a__e
age47154332a_ge
agee56241492agee
agile65122262agile
aglee65728492aglee
aglet65534142aglet
agley96917332agley
agly86821802agly
ague55725922ague
aide56044992aide
ail37171042ail_
ailed66240282ailed
ails45654712ails
aisle55223192aisle
ajee115928232ajee
akee85936812akee
al210674042a_l_
ala312463602a_la
alae45643752alae
alb57342652a_lb
alec66430062a_lec
alee46652322alee
alef76340692a_lef
ales47067102a_les
all36148232a_ll
allee54932122allee
alley85721672alley
alls46740922alls
ally76935642ally
alme65832162alme
aloe45540192aloe
alp56641132a_lp
als36663022a_ls
alt36467962a_lt
amble95924642amble
amie66339852amie
amole75724592amole
ample94720302ample
ane37866942a_ne
anele55628832anele
angle64528872angle
anile54634462anile
ankle95220252ankle
anole55330372anole
ante46538902ante
ape57251182a_pe
apple94517672apple
apse67725382apse
are37874572a_re
argle65421562argle
arles56735742arles
arse46539272arse
ate37059242a_te
auld54125362auld
ave67748702a_ve
awe67746622a_we
awee76336642awee
awl67635302awl_
awls75926092awls
ax911057782ax__
axal116520492axal
axed128829612axed
axels126313632axels
axes117337852axes
axil116424452axil
axils127217502axils
axis116127912axis
axite125218252axite
axlike17388852axlike
axmen145112272axmen
axon115524302axon
axone125918472axone
aye67151762a_ye
azole145118032azole
bale66353842bale
bile66147182bile
bole66448692bole
cable95329912cable
carle74535702carle
cole66956112cole
dale55643982dale
dele56843082dele
dole56550002dole
eagle64219482eagle
exile126117652exile
fable105824752fable
farle86929242farle
file75446642file
gable85325522gable
gale56347322gale
hale76052832hale
haole84820082haole
hole77553392hole
idle55423762idle
isle45121702isle
ixtle12168012ixtle
jole117233822jole
kale86533752kale
ladle66320442ladle
laxly15610102laxly
macle96127002macle
maile75232222maile
male66052292male
maple95521142maple
mile66352572mile
mole66251832mole
mule65236972mule
ogle56325052ogle
ole37155212_ole
orle45630462orle
padle84522342padle
pale66055012pale
parle75836162parle
pele65539552pele
pile65649692pile
pole65951302pole
pule65040952pule
rale45050562rale
rile45650532rile
role45851822role
rule49938422rule
sable74732162sable
sale44959702sale
sole46053672sole
table75429602table
tale46154162tale
tele45040872tele
tile45451442tile
tole46052902tole
tule45735872tule
vale74937342vale
vile76139802vile
vole75236982vole
wale74546432wale
wile75944372wile
wyle105519382wyle
yule75725142yule

Search took 2 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 Filter178691298720.0762351197.4
2DLD Change Limit298721610.92332364.0
3Display Results1611610.0463500.0
 (SQL Overall)1786911611.045170996.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.