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

212 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
loitering103968(None) 
cloistering1444822cloistering
fostering132411262fostering
leistering1147982leistering
lettering102112072lettering
littering102411982littering
livering122012382l_ivering
lobstering1345122lobstering
loppering14237282loppering
lowering122210912lo_wering
lustering102711202lustering
mitering113015402_mitering
portering122012302portering
pottering122612002pottering
roistering1148582roistering
tottering10229612tottering
waitering13310712waitering
altering91917113_altering
bantering122414233bantering
bartering122313643bartering
battering122715143battering
bettering122212753bettering
bitewing1435293_bitewing
bittering122511993bittering
blattering13108713blattering
blistering13107063blistering
blithering16116123blithering
blustering13106183blustering
bolstering1346883bolstering
bordering1338833bordering
bothering152210203bothering
bowering142911713bo_wering
broidering1444673broidering
buttering122312523buttering
cantering122417373cantering
catering112019903_catering
centering122915143centering
chittering16107183chittering
clattering13109233clattering
clobbering17103933clobbering
cloturing1245473clo_turing
clustering13116813clustering
cluttering13106833cluttering
cockering1839693cockering
coffering1838043coffering
cohering142413833co_hering
coinhering1647313coinhering
cointerring1447143cointerring
compering163414163compering
coopering142611323coopering
coppering162810893coppering
cornering12311893cornering
coshering15510023coshering
countering13314473countering
covering142215723co_vering
cowering142514033co_wering
cratering12312653cratering
daikering1536103daikering
dithering1499853_dithering
doctoring1346183doctoring
doddering1335183doddering
dowering132510613do_wering
entering91920053_entering
faltering132211113faltering
festering132413173festering
fettering132310513fettering
filtering13199723filtering
flattering1498743flattering
flittering1486503flittering
flowering1636053flo_wering
flustering14105933flustering
fluttering14106293fluttering
foddering1535163foddering
fosterling1445173fosterling
frittering14105623frittering
gartering112111573gartering
gettering112310033gettering
glistering12106423glistering
glittering1296003glittering
glowering1435653glo_wering
goffering1744483goffering
guttering112410443guttering
haltering132212003haltering
hoidening1435633hoidening
hollering1337743hollering
holstering1447083holstering
homering141512073ho_mering
hoovering1635753hoovering
hosteling1337893hosteling
hovering151911143ho_vering
iteming1037753__iteming
jittering17218423jittering
jointuring1843233jointuring
koshering1735363koshering
laagering1136833laagering
lackering1639373lackering
laddering1237593laddering
lagering102212313l_agering
lairing83715343lai__ring
lappering14258843lappering
latening9711493l_atening
lathering13912253lathering
laveering1336813laveering
lawyering1655213lawyering
layering122310353l_ayering
leathering1488683leathering
lechering1538443lechering
lecturing1237303lecturing
leering83417643l__eering
letterings11226003letterings
levering122212503l_evering
libeling1139873l_ibeling
lightering15246113lightering
likening13246893l_ikening
limbering1488793limbering
lingering11310513lingering
lippering14217883lippering
listening10128953listening
lithoing1236743l_ithoing
livening12248153l_ivening
loathing1247673loat_hing
lobsterings1442893lobsterings
lofting113311313loft__ing
loiding93313403loi__ding
loiter64619173loiter___
loitered938183loiter_ed
loiterer837083loiter_er
loiterers936263loiterers
loiters74116613loiter__s
longeing10177593longe_ing
loosening1044933loosening
looting83019643loot__ing
lotteries9311073lotteries
lotting82917753lo_t_ting
loudening1144743loudening
louring83916503lo__uring
louting83719383lout__ing
lumbering14117933lumbering
lustring9269723lust_ring
mastering122315303mastering
mattering122314053mattering
metering112915633_metering
mitring103514143_mit_ring
moistening1346233moistening
moldering1367863moldering
mongering13310353mongering
monitoring1346233monitoring
mortaring1237943mortaring
mothering152110183mothering
motoring11410953mo_toring
mustering122212333mustering
muttering122611323muttering
nattering102212213nattering
neutering1038963neutering
nidering10510483_nidering
ochering14219393_ochering
offering1536393_offering
ordering1039353_ordering
outring84021023_out_ring
overing111918053_o_vering
oystering1337563oystering
paltering122612893paltering
pattering122314423pattering
peltering122011673peltering
pestering122315663pestering
petering112516813_petering
philtering1646253philtering
plaistering1444603plaistering
plastering1339243plastering
pondering132411333pondering
posturing1238993posturing
pothering151911283pothering
powdering16246503powdering
powering142210803po_wering
puttering122611643puttering
quivering2235873quivering
rogering10310273ro_gering
roystering1445413roystering
shivering1637333shivering
sintering101014803sintering
sistering101213753sistering
skittering1535393skittering
slithering1496893slithering
slivering1338083slivering
slobbering15103883slobbering
sobering111912783so_bering
softening1365493softening
soldering1169033soldering
spiering112713353spi_ering
swithering17105213swithering
tattering102212323tattering
teetering10239893teetering
tentering102313203tentering
tiering8315253_ti_ering
tittering102310313tittering
tochering1537153tochering
toileting1036263toileting
toiting83217093toit__ing
torturing1036253torturing
towering122610873to_wering
twittering1444583twittering
unmitering1345003unmitering
uttering91613083_uttering
watering122316313_watering
weltering13219493weltering
westering132112643westering
whitening1635103whitening
whitewing1943853whitewing
wintering13412363wintering
withering16108813_withering
wondering142110463wondering
yattering132410443yattering

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486412126.40623203.4
3Display Results2122120.0932279.6
 (SQL Overall)1786912126.65526850.6
 
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.