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 “ridleys” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

377 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
ridleys1114578(None) 
ridley10169541ridley_
aidless83612072aidless
bridlers11359182bridlers
bridles104114472bridle_s
diddleys14334632diddleys
idlers74012812_idlers
idles66720122_idle_s
kidneys1533422kidneys
lidless8309272lidless
medleys13115332medleys
midlegs1156322midlegs
redlegs936822redlegs
ribless93410342ribless
riblets93412552riblets
rickeys16548982rickeys
ridders93612492ridders
riddlers10269102riddlers
riddles93215022riddle_s
riders74123902rid_ers
rides66140812rid_e_s
ridgels9348022ridgels
ridges85817012ridge_s
riflers103512192riflers
rifles94217702rifle_s
riles55343642ri_le_s
riley84420582ri_ley_
rilles64725502rille_s
rillets74216152rillets
rimless9369362rimless
rindless92510192rindless
rodless8310072rodless
sidlers83414232sidlers
sidles74721152sidle_s
addles84216603addle_s
aiders74524633aid_ers
aides65336603aid_e_s
aiglets84012913aiglets
aimless93610813aimless
airless73712043airless
aisles64721143aisle_s
alleys95113303_alleys
aridly105513703aridl_y_
aridness939223aridness
baileys12388933baileys
barleys125011843barleys
bedless1039703bedless
bialys11387913bial_ys
bibles104617643bible_s
bibless11439173bibless
bidders114012313bidders
biders94822803bid_ers
bides85536773bid_e_s
bidets95215533bid_ets
biles75542143bi_le_s
billers94720833billers
billets94516153billets
bindles104016453bindle_s
birlers93813003birlers
birles84920643birle_s
brides94423513brid_e_s
bridges113911333bridge_s
bridle94115463bridle__
bridled113611143bridle_d
bridler103811073bridle_r
brimless1235273brimless
brindles113710223brindle_s
budless1038873budless
burleys12479673burleys
chimleys1883633chimleys
ciders94620093cid_ers
cradlers11309203cradlers
cradles103114133cradle_s
deys85027473__d_eys
dialers83614303dialers
dickeys17479303dickeys
diddlers11359153diddlers
diddles103915073diddle_s
diddley13388103diddley_
didies84621833didie_s
didoes85716963didoe_s
dindles93817243dindle_s
dingeys12458403dingeys
dinkeys15507263dinkeys
doyleys14384923doyleys
driblets11266093driblets
drillers9429723drillers
dripless1135243dripless
ediles74016983edile_s
eiders74321363eid_ers
endless839833endless
fiddlers13328283fiddlers
fiddles123212603fiddle_s
fidges114114393fidge_s
fidgets12388763fidgets
filers94623723fi_lers
files85441273fi_le_s
filets94718953fi_lets
fillers104320213fillers
filles94224523fille_s
fillets103414753fillets
finless102810783finless
fleys117015603__fleys
foleys123810463_foleys
fridges12369483fridge_s
frillers11349873frillers
galleys11369713galleys
giblets103210423giblets
giglets93211553giglets
gilders94212463gilders
gillers84216903gillers
gimlets10338433gimlets
girdlers10195403girdlers
girdles92210003girdle_s
gleys96514853__gleys
godless938403godless
gridders11286293gridders
griddles1145753griddle_s
grides84422363grid_e_s
grillers93810813grillers
grilles83715023grille_s
gulleys11438523gulleys
henleys1334843henleys
hickeys19508223hickeys
hideless12278713hideless
hiders104919653hid_ers
hides95129423hid_e_s
hillers103718733hillers
hipless12399923hipless
hitless103211193hitless
hurleys13407333hurleys
ideas65919013_id_eas
ides57734233_id_e_s
idle55423763_idle__
idled74915213_idle_d
idler65015663_idle_r
idlesse834193_idlesse
idlest74014863_idlest
idly85617323_idl_y_
ileus54616893_i_leus
inlays9389873_inlays
inlets63915573_inlets
ireless72312243ireless
irides74519123irid_e_s
isles54220563_isle_s
islets64513083_islets
jitneys17313173jitneys
kidders13399173kidders
kidney1434763kidney_
killers114215583killers
kindlers13318483kindlers
kindles123614843kindle_s
kindless13289243kindless
kinless113310273kinless
ladlers84613573ladlers
ladles74619543ladle_s
leys76430183___leys
limeys11429273li_meys
linseys1035083linseys
lipless9259553lipless
lisles63416283lisle_s
medley1298343medley_
mickeys18447943mickeys
middays14335663middays
middens11379383middens
middlers123410193middlers
middles113415303middle_s
midges103516483midge_s
midgets113910253midgets
midleg1038553midle_g
midways16386183midways
mildens10339933mildens
mildews13365883mildews
milers84625163mi_lers
miles74645073mi_le_s
millers93621343millers
milles84526563mille_s
millets94216843millets
mindless11319443mindless
mislays12349243mislays
mooleys1236863mooleys
motleys1235683motleys
muleys11409643_muleys
mulleys12299203mulleys
nides65229133nid_e_s
nidgets9358143nidgets
oilers64721193oi_lers
oodles73517183oodle_s
orioles7412993oriole_s
padles95221123padle_s
paisleys1333343paisleys
parleys125212373parleys
pedlers103013273pedlers
piddlers12359593piddlers
piddles114314273piddle_s
piglets103311793piglets
piles74742613pi_le_s
pileus84514943pi_leus
pinkeys16378213pinkeys
piolets93513193piolets
prides94324183prid_e_s
pulleys12399143pulleys
pusleys12286233pusleys
raddles93615703raddle_s
raiders84615143raid_ers
railers74420663railers
rainless8129703rainless
rales54947493r_ale_s
rallyes10348553rallyes
rayless10239003rayless
reales64934123reale_s
redbays1336013redbays
reddens9259783reddens
redders93615343redders
reddles93315773reddle_s
redeems1037163redeems
redes65139133red_e_s
redeye103811793red_eye
redeyes112910973red_eyes
redleg839273redle_g
redly94217203redl_y_
redness82012443redness
redoes74623773redoe_s
redress82511873redress
redyes104214093redye_s
reelers73520273reelers
reflets103513153reflets
reglets83512983reglets
reinless8139433reinless
rekeys13347693r_ekeys
relays94316753r_elays
relets64025673r_elets
replays12399763replays
rials55026673rial__s
rialtos736613rialtos
ribbers113913183ribbers
ribes75530173ri_be_s
ribiers9319753ribiers
riblet84222443rible_t
ricers84120993ri_cers
rices75536153ri_ce_s
richens12349733richens
riches115022083riche_s
rickets134915093rickets
rickey154613973rickey_
ridded93615123ridde_d
ridden83511723ridde_n
ridder84015143ridde_r
riddle83915713riddle__
riddled103012043riddle_d
riddler93411263riddle_r
ride55945133rid_e__
rident7520193rid_ent
rider65231303rid_e_r
riderless1044903riderless
ridge75018673ridge__
ridged94014223ridge_d
ridgel8399973ridge_l
ridgils9326573ridgils
ridgy104110643rid_gy_
ridings93412093ridings
rids56539553rid___s
riels55121333ri__els
rievers104311453rievers
rifely123710033rifely_
rifflers14336443rifflers
riffles133911163riffle_s
rifle85518333rifle__
rifled104115003rifle_d
rifler94014263rifle_r
riflery13345803riflery
riflips1234163riflips
riftless1136943riftless
riggers93613843riggers
rile45650533ri_le__
riled65833253ri_le_d
rille55728733rille__
rilled74525653rille_d
rillet64828853rille_t
rills55032713ri_l_ls
rimers84522553ri_mers
rimes75634543ri_me_s
rimmers113812883rimmers
rimples113114223rimple_s
ringers83922953ringers
ringlets92910233ringlets
rinsers73815743rinsers
rinses64720383rinse_s
rioters73615513rioters
ripely112511153ripely_
ripens85012173ri_pens
ripes75435773ri_pe_s
rippers114115033rippers
ripplers12337113ripplers
ripples113513293ripple_s
ripplets12316733ripplets
risers64624783ri_sers
rises55244043ri_se_s
riskers114011993riskers
riskless1235763riskless
rites54442553ri_te_s
ritters74020623ritters
ritzes154812943ritze_s
rivers94626543ri_vers
rives85336003ri_ve_s
rivets94417113ri_vets
rivulets1174753rivulets
roadless937703roadless
robles85321693roble_s
rodeos75314503rod_eos
rodes614039083rod_e_s
roles56747983r_ole_s
rollers73117473rollers
rubles83921703ruble_s
rudders93210653rudders
ruddles92813873ruddle_s
rudely10389973rudely_
rulers64317093r_ulers
rules55234253r_ule_s
rundles83214713rundle_s
rundlets9307363rundlets
runless72810423runless
runlets73310773runlets
sides65838363sid_e_s
sidle65124033sidle__
sidled84215173sidle_d
sidler74716963sidle_r
sillers73822103sillers
sinless73014213sinless
smileys12336323smileys
tiddlers10288653tiddlers
tideless9269083tideless
tides64830153tid_e_s
tidiers8389773tidiers
tidies74721833tidie_s
tieless72512563tieless
tildes74513963tilde_s
tilers63523503ti_lers
tiles55542103ti_le_s
tillers73418743tillers
tipless92610063tipless
titles63719923title_s
trawleys14284383trawleys
triflers113110213triflers
trifles103814823trifle_s
trillers83613493trillers
trindles93211683trindle_s
triolets83410143triolets
triples94616873triple_s
triplets103510263triplets
trolleys11315693trolleys
valleys13407483valleys
videos104911373vid_eos
violets102210003violets
volleys13316643volleys
widders123512273widders
widdles123514343widdle_s
widely133311033widely_
widens106212723wid_ens
wides94832823wid_e_s
widgets12318453widgets
wifeys15425873wi_feys
wigless11359673wigless
wiglets113411423wiglets
wilders113513503wilders
wiles85437873wi_le_s
willers103517913willers
willets104414323willets
winceys15395523winceys
windles113518493windle_s
windless123310863windless
winless103212283winless
witless103310983witless
witneys13274723witneys
yodlers11298923yodlers
yodles103714333yodle_s
zipless18276303zipless

Search took 7 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 Filter1786911340270.403443402.0
2DLD Change Limit1340273775.92322628.2
3Display Results3773770.1233065.0
 (SQL Overall)1786913776.44927708.3
 
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.