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

379 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
limited10231023(None) 
limiteds11184541limiteds
limiter92710851limiter
limites92915451limites
delimited1346592delimited
elicited1139092elicited
lenited8812432lenited
liaised837112liaised
lichted13268802lichted
lifted104413522li_fted
ligated92414142ligated
lighted122913502lighted
lilied73913212lili_ed
lilted73715372li_lted
limbed114513182lim_bed
limed85426802lim__ed
limier83518722limi_er
limit73126342limit__
limitedly1542592limitedly
limiters10249332limiters
limits82514142limit_s
limned94811472lim_ned
limped114817122lim_ped
linted74021822li_nted
listed74322832li_sted
unlimited1245922unlimited
visited1168772visited
vomited1337252vomited
admired1135703admired
admitted1234763admitted
admixed1833733admixed
aimed85626053aim__ed
airted74214503ai_rted
alibied1038143alibi_ed
alighted1347673alighted
alimented1245313alimented
animated111612373animated
audited939033audited
awaited1146963awaited
baited95319243_baited
bemired123410633bemired
bemisted1368383bemisted
bemixed19337053bemixed
bighted142810923bighted
bigoted11258403bigoted
bilsted1038033bilsted
bitted94418483bi_tted
blighted1546863blighted
bruited104110353bruited
ciliated11510953ciliated
cimices13279803cimices
cisted95217523ci_sted
cited84421953__cited
citied94014143citi_ed
climate11312833climate_
climates12311973climates
climaxed2043113climaxed
climbed14336983clim_bed
compted143813523compted
debited113311623debited
delimiter1246243delimiter
demised113613683demised
demitted12288773demitted
demoted114313543demoted
dieted83115493di_eted
dighted132511493dighted
dilated93115823dilated
diluted9248933diluted
dimeter10411893dimeter
dimities11314003dimities
dimity12310483dimit_y
dimmed124110323dim_med
dimpled132810303dimpled
dimwitted1642293dimwitted
dinted84419843di_nted
dirtied93210853dirtied
divided13378593divided
divined12329693divined
doited85016633_doited
edited83913673_edited
eliminated1345953eliminated
emitted103010853emitted
emoted94614923_emoted
endited93512913endited
ermined10410603ermined
evited104013143_evited
excited1737853excited
exited144712523_exited
fileted1159093fileted
filiated12610083filiated
finite9316823finite_
finites10315923finites
fisted104218703fi_sted
fitted104716663fi_tted
fixated1835533fixated
flighted1646973flighted
flinted114411893fli_nted
flirted11428673fli_rted
flited104616583_flited
flitted114011643fli_tted
fomite113314073fomite_
fomites123613203fomites
fruited11389093fruited
gaited84416923_gaited
gifted114510703gi_fted
gimleted1243973gimleted
gimped123911473gim_ped
girted83912873gi_rted
gitted84015053gi_tted
glimed105312283glim__ed
glimpsed1442773glimpsed
glinted9399373gli_nted
habited1337883habited
highted152710163highted
hilted104016043hi_lted
hinted104318323hi_nted
histed104420243hi_sted
ignited9137623ignited
illite63414923illite_
illites72415013illites
imaged1097763_imaged
imbed105013653_im_bed
imbibed1433733_imbibed
imbued1136173_imbued
imid76122293_imi__d
imide85716893_imide_
imides94515343_imides
imine75821063_imine_
imines84918353_imines
imitated1138263_imitated
immixed1933573immixed
imped105117983_im_ped
impled113812513_impled
imputed1236533_imputed
incited103314623incited
indited93515023indited
invited113612463invited
irised73913153_irised
ivied94710523_ivi_ed
jilted144111353ji_lted
jimmied19275033jimmied
kibitzed2442043kibitzed
kilted113613833ki_lted
kited105120093__kited
kitted115114833ki_tted
labiated11109303labiated
laicised1145643laicised
laicized2046043laicized
laired75216813l_aired
lambed115614783lam_bed
lamed85235293lam__ed
lamented1138193lamented
lamiae84817453lamiae_
laminated122610283laminated
lamister1037653lamister
lammed113915623lam_med
lamped114017543lam_ped
lamster9109913lamster
lanated8313203lanated
lariated91212063lariated
lasted74323603l_asted
lated65240673l__ated
lazied164610653lazi_ed
legated92513983legated
lenite6719983lenite_
lenites7818443lenites
letted74118543l_etted
levied104111433levi_ed
liaise6310693liaise_
liaises7311053liaises
libeled10249413libeled
librated113110313librated
licit74327683licit__
licitly12276673licitly
licked134621563li_cked
lidded93410243li_dded
lied55838093l__i_ed
lifter93814813li_fter
ligate72519253ligate_
ligates82318383ligates
lighten112811523lighten
lighter113113443lighter
lignite81310303lignite_
lignites9129613lignites
liked104523813l__iked
likened12267353likened
lilies63021413lili_es
limbate1139213limbate_
limber104316793lim_ber
limbered13158123limbered
limbier11349113limbier
lime66244933lim__e_
limeade1076123limeade
limen75426033lim__en
limes75636503lim__es
limey104721043lim__ey
limiest93716103limiest
limina83514503limi_na
liminal93810673liminal
liminess10510643liminess
liming94021243limi_ng
limitary1344933limitary
limiting1138813limiting
limitless1142943limitless
limmer104314793lim_mer
limner84112873lim_ner
limonite1048163limonite_
limonites1148003limonites
limper104117853lim_per
limpet103518633lim_pet
limpets11329783limpets
limpid11389753lim_pid
limpsey14365093limpsey
lineated9711063lineated
lined64934643l__ined
linier64423793lini_er
linked114518213li_nked
linseed838203linseed
lintel64013993li_ntel
linter64625343li_nter
lintier73613803lintier
lionised946603lionised
lionized1837023lionized
lipid85916173lipi__d
lipide93511063lipide_
lipides103810623lipides
lipped114419543li_pped
liquated1835493liquated
lisped94113423li_sped
listee64223063li_stee
listel64214743li_stel
listen64816813li_sten
lister64527253li_ster
lite47054543l__ite_
liter54736343l__iter
lithoed1137833lithoed
litigated1146563litigated
litotes7311183litotes
litten64014873li_tten
litter64324853li_tter
lived95523723l__ived
livened11238933livened
livered113111633livered
livid96714423livi__d
livier97514593livi_er
lobated102610943lobated
located103114183located
lofted103811893l_ofted
loided83414023l_oided
loiter64619173l_oiter
looted74421113l_ooted
lotted74222403l_otted
louted74920693l_outed
lucite8313343lucite_
lucites9311863lucites
lumped114216963lum_ped
lunated8310823lunated
lunted74517523l_unted
lusted74319443l_usted
luted64826143l__uted
luxated1535713luxated
lyrated11388473lyrated
mated85537783__mated
merited10313853merited
meted85424433__meted
miked125020453__miked
milted93919943mi_lted
mimed105622733__mimed
mimeoed1235193mimeoed
mimicked1943253mimicked
mined85333353__mined
minted94220583mi_nted
minuted10329503minuted
mired85729223__mired
miscited13310423miscited
mismated131111333mismated
misted93625823mi_sted
mite66249413__mite_
miter75734793__miter
mites75141803__mites
mitred94414343__mitred
mixed155717253__mixed
muted85023383__muted
nidated939863nidated
nimiety1244633nimiety
nimmed11368573nim_med
omitted10347893omitted
orbited1037733orbited
picoted1239213picoted
piloted10310323piloted
pimped134913483pim_ped
pimpled14289193pimpled
pinite8321243pinite_
pinites9319533pinites
pirated102515613pirated
pitied94017253piti_ed
pitted94319593pi_tted
pivoted1336513pivoted
plaited103713893plaited
plicated13310643plicated
plighted1546463plighted
plumiped1533313plumiped
posited10511493posited
prelimited1545493prelimited
pumiced1435173pumiced
quoited1756403quoited
recited104319103recited
remated103522473remated
reminted113615083reminted
remised103516843remised
remitted113312073remitted
remixed173510743remixed
resited85122423resited
rifted104115313ri_fted
righted122912143righted
rimed84826373rim__ed
rimier83916273rimi_er
rimmed114812303rim_med
rimpled123311423rimpled
rioted73416373ri_oted
riveted11258573riveted
samite83020603samite_
samites93118713samites
scimiter1236143scimiter
sifted104313673si_fted
sighted123111523sighted
silted74020013si_lted
simile83115633simile_
similes92915233similes
simioid1047993simioid
simitar936733simitar
sited65130743__sited
skited114313483_skited
slighted1357393slighted
slimed94915123slim__ed
slimier93212013slimi_er
slimmed12368473slim_med
slitted83513313sli_tted
smiled93716433_smiled
smite75224873_smite_
smiter83616413_smiter
smites83921923_smites
solicited1247973solicited
somite84519373somite_
somites94219123somites
sopited104211063sopited
spirited1148973spirited
spited94820443_spited
stimied10310623stimi_ed
suited74019423_suited
summited13246413summited
tempted12317283tempted
tidied83613273tidi_ed
tilted74616863ti_lted
timed85223613tim__ed
timid84815733timi__d
timider1037093timider
tincted1037273tincted
tinted74419533ti_nted
toited74016753_toited
ultimated1247313ultimated
united74421543_united
unmated103317023unmated
unmined102612953unmined
unmiter9310393unmiter
unmitred1136843unmitred
unmixed17228213unmixed
visiter1038863visiter
vitiated12289223vitiated
vomiter1237953vomiter
waited103819773_waited
whited134814083_whited
wilted103915713wi_lted
wimbled15298153wimbled
wimped144211513wim_ped
wimpled15338823wimpled
wisted104120273wi_sted
wited94727143__wited
witted104216813wi_tted

Search took 8 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.406440125.6
2DLD Change Limit1340273796.54620474.6
3Display Results3793790.1432650.3
 (SQL Overall)1786913797.09525185.5
 
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.