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

123 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
amole7572459(None) 
amble95924641amble
amoles84122191amoles
ample94720301ample
anole55330381anole
azole145118031azole
mole66251831_mole
abele76323252abele
able66340532a_ble
abode85518812abode
above105414322above
acold86214932acold
addle74318352addle
adobe84814712adobe
adore65723672adore
adoze155713832adoze
afore85818602afore
agile65122262agile
agone65924552agone
ahold94714252ahold
aioli5318312aioli
aisle55223192aisle
ale36572342a__le
aloe45540192alo_e
alone55732962alone
amaze166016602amaze
ambled115116372ambled
ambler104916452ambler
ambles105121862ambles
amice96122872amice
amide86128482amide
amie66339852am_ie
amine75835382amine
amok10217402amo_k
amoks11413552amoks
among85813302among
amort75832202amort
amour75014852amour
ampler104313302ampler
amply125012912amply
ampoule11116602ampoule
ampule10710612ampule
amulet8419572amulet
amuse75920832amuse
amyl95515102amyl_
amyls104512692amyls
anele55628832anele
angle64528882angle
anile54634462anile
ankle95220252ankle
anode65021042anode
anoles64827432anoles
apple94517672apple
areole61017282areole
argle65421562argle
armhole1236942armhole
arose55832082arose
atoll57913922atoll
atone56527982atone
awoke124912002awoke
awol75620672awol_
awols84713522awols
axile126020512axile
axle116424602a_xle
axone125918472axone
azoles154614612azoles
azote144416342azote
bole66448692_bole
cajole154011182cajole
cole66956112_cole
dhole95215362dhole
dole56550002_dole
emote75421192emote
gamble115417182gamble
haole84820082haole
hole77553392_hole
jole117233822_jole
macle96127002macle
maile75232222maile
male66052302_male
maple95521142maple
mile66352572_mile
mode75840302_mode
moke106234222_moke
mol56654592_mol_
mola66035632_mola
mold76034332_mold
moles74747922_moles
moll66735702_moll
mols65948572_mols
molt66356162_molt
moly96031912_moly
mome85239352_mome
mope86838042_mope
more67154522_more
mote67048082_mote
moue65835572_moue
move96630722_move
mule65236972_mule
obole75917142obole
ole37155212__ole
osmole8128512osmole
parole84425252parole
pole65951302_pole
prole74527792prole
ramble104519972ramble
ramose8314402ramose
rampole1139692rampole
role45851822_role
sample104215012sample
smile74823922smile
smoke115015822smoke
smolt74824162smolt
smote75820282smote
sole46053672_sole
stole54928812stole
tamale83717402tamale
thole85620842thole
tole46052902_tole
vamose1159282vamose
vole75236982_vole
wamble134415752wamble
whole114418092whole

Search took 5 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.610292936.1
2DLD Change Limit538001233.39015870.2
3Display Results1231230.0801537.5
 (SQL Overall)1786911234.08043796.8
 
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.