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

248 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
loitered93818(None) 
loiterer837081loiterer
cloistered1344522cloistered
cottered112511742cottered
fostered122210452fostered
leistered1037042leistered
lettered92910782lettered
littered92511382littered
livered113111632l_ivered
lobstered1244642lobstered
loiter64619172loiter__
loiterers936262loiterers
loiters74116612loiter_s
loppered13326752loppered
louvered1244992louvered
lowered112711912lo_wered
lustered92510612lustered
mitered103213232_mitered
portered112311552portered
pottered112311662pottered
roistered1037652roistered
tottered9208702tottered
waitered1238762waitered
altered83215753_altered
bantered113313653bantered
bartered113113033bartered
battered113315073battered
bettered113011843bettered
bistered112913333bistered
bittered112711833bittered
blattered12198583blattered
blistered12167683blistered
blithered15156123blithered
blustered12157263blustered
bolstered1246093bolstered
bordered1248933bordered
bothered142110393bothered
bowered133113043bo_wered
broidered1344933broidered
buttered112712633buttered
cantered113415993cantered
catered103117783_catered
centered112513523centered
chittered15166413chittered
clattered12178423clattered
clobbered16164103clobbered
clotured11246163clo_tured
clovered14187363clo_vered
clustered12186613clustered
cluttered12185943cluttered
cockered17710213cockered
coffered1737673coffered
cohered133514693co_hered
coinhered1536593coinhered
cointerred1346563cointerred
compered153414923compered
coopered133310943coopered
coppered153410543coppered
cornered11311133cornered
coshered14610293coshered
countered12313003countered
covered133315293co_vered
cowered133214653co_wered
cratered1149693cratered
daikered1495223daikered
dithered13189293_dithered
doctored1245623doctored
doddered1234943doddered
doited85016633doit__ed
donnered10307753donnered
dormered1255673dormered
dotterel945063dotterel
dowered122811553do_wered
entered82718883_entered
faltered122811003faltered
festered122512113festered
fettered12259493fettered
fibered1337643_fibered
filtered12259043filtered
flattered13188643flattered
flittered13196253flittered
flowered1546013flo_wered
flustered13185883flustered
fluttered13185943fluttered
foddered1434553foddered
fosterer11239523fosterer
frittered13205163frittered
gartered10319603gartered
gettered10258613gettered
glistered11176303glistered
glittered11195413glittered
glowered1345753glo_wered
goateed9307063goate_ed
goffered1634523goffered
goiter74116203goiter__
goiters84014443goiter_s
goitre7349003goit_re_
goitres8389563goit_res
guttered10259173guttered
haltered123112573haltered
hoidened1335653hoidened
hollered1237603hollered
holstered1345883holstered
homered133212713ho_mered
hoovered15195413hoovered
hosteled1237293hosteled
hovered143411573ho_vered
itemed936603__itemed
jittered16267223jittered
jointured17133483jointured
koshered1636063koshered
laagered1055853laagered
lackered15108683lackered
laddered1136743laddered
lagered92311153l_agered
laired75216813lai__red
lappered13288213lappered
latened8711923l_atened
laterad8310853l_aterad
lathered121512333lathered
laveered1235253laveered
lawyered1534033lawyered
layered11259413l_ayered
leathered13148713leathered
lechered1437523lechered
lectured11127233lectured
leered73816223l__eered
leisured934763leisured
letterer8259223letterer
levered114212303l_evered
libeled10249413l_ibeled
lightered1446283lightered
likened12267353l_ikened
limbered13158123limbered
linebred1144963l_inebred
lingered10129643lingered
lippered13287953lippered
listened9168813listened
liter54736343l_iter__
literal7613273l_iteral
liters65429883l_iter_s
lithoed1137833l_ithoed
litre55421463l_it_re_
litres65220393l_it_res
litterer82810173litterer
livened11238933l_ivened
liveried1238733l_iveried
loathed11419443loat_hed
lobsterer1144033lobsterer
lofted103811893loft__ed
lofter94614723lofter__
lofters103912903lofter_s
loided83414023loi__ded
loitering1039683loitering
loosened945453loosened
looted74421113loot__ed
looter64222323looter__
looters74419163looter_s
lotted74222403lo_t_ted
lotter64025603lotter__
lotteries9311083lotteries
lotters73921063lotter_s
lottery10389833lotter_y
loudened1044693loudened
loured74617403lo__ured
louted74920693lout__ed
louvred11354663lo_uvred
lowbred13225363lo_wbred
lumbered13188233lumbered
lustred8359053lust_red
mastered112614013mastered
mattered112412913mattered
metered103514013_metered
miterer92511333_miterer
mitred94414343_mit_red
moistened1246003moistened
moldered1237173moldered
mongered1238953mongered
monitored1245583monitored
mortared1137213mortared
mothered142310103mothered
motored1039933mo_tored
mustered112511513mustered
muttered112610803muttered
nattered92011633nattered
neutered937423neutered
ochered132610283_ochered
offered1436143_offered
ordered9108533_ordered
osiered837123_osiered
outbred10311263_outbred
overed102216623_o_vered
oystered1236923oystered
paltered113012503paltered
pattered112714213pattered
peltered112510453peltered
pestered112814973pestered
petered103314973_petered
philtered1545493philtered
plaistered1344133plaistered
plastered1288913plastered
poitrel936193poit_rel
pondered126411293pondered
postured1139493postured
pothered142311043pothered
potterer102310263potterer
powdered15256893powdered
powered132911643po_wered
puttered112611153puttered
quivered2144833quivered
raftered1237673raftered
rogered939553ro_gered
roisterer946433roisterer
roystered1344873roystered
shivered15177103shivered
sintered92213903sintered
sistered92612803sistered
skittered1434633skittered
slithered13136623slithered
slivered12218103slivered
slobbered14144223slobbered
sobered102912433so_bered
softened1235663softened
soldered1038153soldered
spiered104412463spi_ered
swithered16135463swithered
tattered92011453tattered
teetered9258303teetered
tentered96412103tentered
tiered73613973_ti_ered
tittered9239493tittered
tochered1437913tochered
toileted936993toileted
toited74016753toit__ed
tortured935843tortured
totterer8217793totterer
towered112911403to_wered
twittered1333813twittered
unmitered1245853unmitered
uttered82712443_uttered
watered113014963_watered
weltered12238443weltered
westered122511873westered
whitened1535183whitened
wintered122111573wintered
withered15169433_withered
wondered13239943wondered
yattered12239543yattered

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 Filter1786911461620.420425454.8
2DLD Change Limit1461622487.40619735.6
3Display Results2482480.1102254.5
 (SQL Overall)1786912487.93622516.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.