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

144 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
ariled7562032(None) 
ailed66240281a_iled
argled85314551argled
railed74727541railed
riled65833251_riled
abided105313312abided
abled86926832a_bled
addled94112522addled
aeried74221862aeri_ed
afield1035952afield
agile65122262agile_
aided75828932a_ided
aimed85626052a_imed
aired66032922a_ired
airted74214502airted
aisled74516182aisled
alined75221402alined
aliped95414282aliped
allied74217152allied
ambled115116372ambled
aneled74719282aneled
angled84219092angled
anile54634462anile_
ankled114313482ankled
anviled1138952anviled
arced88224162ar_ced
arched125717322arched
arcked136211942arcked
argle65421562argle_
argles75218482argles
argued84311172argued
arid57642712ari__d
arider74717742arider
ariel55228972ari_el
ariels65119372ariels
aril45843022aril__
arils58732202aril_s
arise56436432arise_
arisen65316792arisen
arises65233802arises
arles56735742ar_les
armed86324432ar_med
armlet84118192armlet
arrived11127352arrived
articled1137062articled
auricled11135702auricled
availed1135972availed
axile126020512axile_
axised14438962axised
axled135315812a_xled
bailed94726652bailed
birled94416992birled
boiled95020952boiled
brailed103914012brailed
bribed115312842bribed
bridled113611142bridled
brined95118412brined
broiled103811422broiled
caried94528692cari_ed
caroled103717692caroled
caviled1348722caviled
ceiled94114952ceiled
coiled95123942coiled
cried84624282cri_ed
darkled13378722darkled
dartled9409852dartled
dirled84514902dirled
doiled84817292doiled
dried75321382dri_ed
drilled94711672drilled
exiled144712462exiled
failed105421602failed
filed95331902_filed
foiled104618402foiled
fried95322912fri_ed
frilled113911602frilled
frized193510682frized
garbled114512802garbled
gargled104210672gargled
grided95117042grided
grilled94012832grilled
grimed104714092grimed
griped104114712griped
guiled84315382guiled
hailed104122742hailed
heiled104415612heiled
irised73913152irised
jailed144917422jailed
mailed95326752mailed
marbled123212112marbled
marled95523162mar_led
moiled94318862moiled
nailed74021492nailed
oiled64429472_oiled
parled94626292par_led
paroled104217632paroled
periled10316322periled
piled85232992_piled
priced115018882priced
prided103618032prided
pried84426862pri_ed
prilled104713002prilled
primed115118912primed
prised94322202prised
prized184415392prized
raided85017702raided
railer64524932railer
rained75024602rained
raised76120332raised
riced85825542_riced
rifled104115002_rifled
rile45650532_rile_
riles55343642_riles
riley84420582_riley
rilled74525652_rilled
rimed84826372_rimed
riped85226432_riped
rived94825612_rived
roiled74320052roiled
ruled65822522_ruled
sailed74327762sailed
smiled93716432smiled
soiled73822472soiled
spiled94621992spiled
tailed74424662tailed
tiled64832942_tiled
tirled74714362tirled
toiled74420322toiled
trailed83415672trailed
triced95518672triced
tried65026912tri_ed
trifled113711962trifled
trilled84116312trilled
trined74920712trined
tripled104113832tripled
vailed104619292vailed
varied104817862vari_ed
veiled103714542veiled
wailed104823592wailed
warbled133212162warbled
warsled112910442warsled
whiled134514132whiled
wiled95231552_wiled
wried95518562wri_ed

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.330541487.9
2DLD Change Limit825511442.28036206.6
3Display Results1441440.0463130.4
 (SQL Overall)1786911442.65667278.2
 
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.