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

259 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
limiting113881(None) 
delimiting1445842delimiting
eliciting1237772eliciting
leniting9312352leniting
liaising937912liaising
lichting14268512lichting
lifting113313272li_fting
ligating102212282ligating
lighting132811832lighting
lilting83515382li_lting
limbing123410422lim_bing
liming94021242lim__ing
limitingly1643492limitingly
limning103710322lim_ning
limping124614112lim_ping
linting83820982li_nting
listing84020592li_sting
smiting103014442_smiting
visiting1238392visiting
vomiting1437732vomiting
admiring1236133admiring
admitting1345033admitting
admixing1944133admixing
aiming94320843aim__ing
airting83616303ai_rting
alibiing1135323alibi_ing
alighting1446413alighting
alimenting1344503alimenting
animating12312503animating
auditing1039033auditing
awaiting1238273awaiting
baiting103918883_baiting
bemiring13239603bemiring
bemisting1438073bemisting
bemixing20226523bemixing
bighting15269453bighting
biting95321823__biting
bitting103717293bi_tting
blighting1635733blighting
bruiting11259973bruiting
citing94220183__citing
climaxing2143493climaxing
climbing15205983clim_bing
compting153013603compting
debiting122511203debiting
demising122012523demising
demitting13239073demitting
demoting12311423demoting
dieting93616833di_eting
dighting142510843dighting
dilating102714903dilating
diluting10248983diluting
dimities11314003dimities
dimming13339593dim_ming
dimpling14199023dimpling
dinting93520553di_nting
dividing1437183dividing
divining1338413divining
editing9313133_editing
eliminating1445533eliminating
emitting112410353emitting
emoting10313563_emoting
enditing10311073enditing
eviting11511373_eviting
exciting1838013exciting
exiting15311393_exiting
fighting162710083fighting
fileting1239303fileting
filiating1339243filiating
finiking16277073finiking
fisting113818123fi_sting
fitting113516563fi_tting
fixating1936183fixating
flighting1736103flighting
flinting123412343fli_nting
flirting12319013fli_rting
fliting113514613_fliting
flitting123010883fli_tting
fruiting12229063fruiting
gaiting93716583_gaiting
gifting123810893gi_fting
gimleting1343863gimleting
gimping133710763gim_ping
girting93113333gi_rting
gitting93215703gi_tting
gliming113310133glim__ing
glimpsing1542593glimpsing
glinting103210053gli_nting
habiting1437533habiting
highting16259723highting
hilting113316893hi_lting
hinting113919223hi_nting
histing113720373hi_sting
hitting113017273hi_tting
igniting1037363igniting
imaging1138083_imaging
imbibing1534043_imbibing
imbuing1236103_imbuing
imitating1238763_imitating
immixing2043543immixing
imping114315353_im_ping
imputing1336853_imputing
inciting11312533inciting
inditing10312113inditing
inviting1239733inviting
irising83614423_irising
jilting153211743ji_lting
jimmying2342383jimmying
kibitzing2542333kibitzing
kilting123213853ki_lting
kiting114117093__kiting
kitting123214443ki_tting
laicising1245623laicising
laicizing2145713laicizing
lairing83715343l_airing
lambing123412413lam_bing
lamenting1237693lamenting
laminating1348723laminating
laming94528363lam__ing
laminin939973laminin_
laminins1039133laminins
lamming123014583lam_ming
lamping123116003lam_ping
lariating10311783lariating
lasting84725243l_asting
legating102313113legating
lemming12269393lem_ming
letting83218533l_etting
libeling1139873libeling
librating1239053librating
licking144118283li_cking
lidding103611433li_dding
lightings14277723lightings
lightning14286023lightning
likening13246893likening
liking114319583l__iking
limacine1246003limacine
limbering1488793limbering
limina83514503lim__ina
limit73126343limit___
limitary1344933limitary
limited102310233limit_ed
limiteds11184543limiteds
limiter92710853limit_er
limiters10249333limiters
limites92915453limit_es
limits82514143limit__s
limpkin1534223limpkin_
limpkins1644233limpkins
lining74526803l__ining
linking123818253li_nking
lionising1046463lionising
lionizing1947053lionizing
lipping123016073li_pping
liquating1946313liquating
lisping103412753li_sping
listings93310043li_stings
lithoing1236743lithoing
litigating1246743litigating
livening12248153livening
livering122012383livering
living104318323l__iving
locating11311503locating
lofting113311313l_ofting
loiding93313403l_oiding
looting83019643l_ooting
lotting82917753l_otting
louting83719383l_outing
lumping123314643lum_ping
lunting83817743l_unting
lusting83619323l_usting
luting75221753l__uting
luxating1645613luxating
mating94832913__mating
meriting11314683meriting
meting94320593__meting
miking134218463__miking
milting103619123mi_lting
mimeoing1336143mimeoing
mimicking2043873mimicking
miming114317263__miming
mining94225453__mining
minting103020813mi_nting
minuting1139723minuting
miring93723803__miring
misciting1439673misciting
mismating141211823mismating
misting103623383mi_sting
mitring103514143__mitring
mixing164713943__mixing
muting93921523__muting
nidating1039783nidating
nimming12358143nim_ming
omitting11217743omitting
orbiting1138153orbiting
picoting1338883picoting
piloting1139693piloting
pimping143812123pim_ping
pirating11314513pirating
pitting103618873pi_tting
pivoting1436183pivoting
plaiting113113513plaiting
plighting1635563plighting
positing11312303positing
prelimiting1645383prelimiting
pumicing1535843pumicing
quoiting1836093quoiting
reciting113118073reciting
remating112322413remating
reminting122315103reminting
remising112516453remising
remitting122412623remitting
remixing182810333remixing
resiting93521123resiting
rifting113515003ri_fting
righting132610853righting
riming93322223rim__ing
rimming123411073rim_ming
rimpling13219663rimpling
rioting82716393ri_oting
riveting12139443riveting
sifting113014593si_fting
sighting133110863sighting
silting83320483si_lting
siting74126623__siting
sitting83519633si_tting
skiting123812493_skiting
slighting1436373slighting
sliming102913953slim__ing
slimming13288093slim_ming
slitting93012583sli_tting
smiling103915443_smiling
soliciting1346813soliciting
sopiting11310763sopiting
spiriting1238413spiriting
spiting103917623_spiting
suiting83419003_suiting
summiting1445793summiting
tempting1357343tempting
tilting83417103ti_lting
timing93619303tim__ing
tincting1148883tincting
tinting84620603ti_nting
toiting83217093_toiting
ultimating1386803ultimating
uniting8315823_uniting
unmitring1245263unmitring
unmixing1835543unmixing
vitiating1338403vitiating
waiting113618953_waiting
whiting143311303_whiting
wilting113515913wi_lting
wimbling16186543wimbling
wimping153911013wim_ping
wimpling16207483wimpling
wisting113519743wi_sting
witing103522823__witing
witting113417063wi_tting
writing113713893_writing

Search took 9 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 Filter1786911461620.250714764.0
2DLD Change Limit1461622597.72018932.9
3Display Results2592590.0932784.9
 (SQL Overall)1786912598.06322161.9
 
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.