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

189 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
loppered1332675(None) 
coppered153410541coppered
lappered13288211lappered
lippered13287951lippered
choppered1964882choppered
compered153414922compered
coopered133310932coopered
kippered17255622kippered
lappeted13255832lappeted
lippened13255222lippened
loitered938182loitered
lopped114218622lopp__ed
lopper103717202lopper__
loppers113014102lopper_s
louvered1244992louvered
lowered112711912lo_wered
peppered1236122peppered
slippered1434822slippered
stoppered1444472stoppered
zippered22244822zippered
appeared1336143_appeared
bopped134413403bopp__ed
bopper123813833bopper__
boppers133911923bopper_s
bordered1248933bordered
bothered142110393bothered
bowered133113043bo_wered
bumpered1536003bumpered
capered123014043_capered
chippered1945003chippered
ciphered1637053ciphered
clobbered16164103clobbered
clopped143611523clopp__ed
clovered14187363clo_vered
coappeared1742273coappeared
cockered17710213cockered
coffered1737673coffered
cohered133514693co_hered
compared153811823compared
compeered1646303compeered
compere134616623compere_
comperes143217973comperes
competed154113593competed
copped135221253copp__ed
copper124321893copper__
copperah17304903copperah
copperas14308573copperas
copperhead2042353copperhead
coppers133519753copper_s
coppery16409393copper_y
coppiced1734823coppiced
cornered11311133cornered
coshered14610293coshered
cottered112511733cottered
covered133315293co_vered
cowered133214653co_wered
cyphered1934653cyphered
dapperer1335763dapperer
diapered1238003diapered
doddered1234943doddered
donnered10307753donnered
dormered1255673dormered
dowered122811553do_wered
flopped15338763flopp__ed
flopper14328473flopper__
floppers15337463flopper_s
flowered1546013flo_wered
foddered1434553foddered
fopped144012673fopp__ed
fopperies1666013fopperies
foppery17385623fopper_y
fostered122210453fostered
glopped13347613glopp__ed
glowered1345753glo_wered
goffered1634523goffered
hampered16239933hampered
happened1635653happened
hollered1237603hollered
homered133212713ho_mered
hoovered15195413hoovered
hopped144318113hopp__ed
hopper134218483hopper__
hoppers143115143hopper_s
hoppled15338083hopp_led
hovered143411573ho_vered
kipperer16294723kipperer
koshered1636063koshered
laagered1055853laagered
lackered15108673lackered
laddered1136743laddered
lagered92311153l_agered
lapeled10258893l_apeled
lapped114320033lapp__ed
lapper104319953lapper__
lappers113717463lapper_s
lathered121512323lathered
laveered1235253laveered
lawyered1534033lawyered
layered11259413l_ayered
lechered1437523lechered
leered73816223l__eered
lettered92910783lettered
levered114212303l_evered
limbered13158123limbered
lingered10129643lingered
lipped114419543lipp__ed
lipper104219633lipper__
lippers113416443lipper_s
littered92511383littered
livered113111633l_ivered
lobstered1244643lobstered
loiterer837083loiterer
looped95217173loop__ed
looper83817113looper__
loopers93914033looper_s
loosened945453loosened
loped85128333lo_p__ed
loper75129233lo_per__
lopers84424143lo_per_s
loppering14237283loppering
loppier11369723lopp_ier
lopsided1244253lopsided
loudened1044693loudened
louped95316383loup__ed
loured74617403lo__ured
louvred11354663lo_uvred
lowbred13225363lo_wbred
lumbered13188233lumbered
lustered92510603lustered
moldered1237173moldered
mongered1238953mongered
mopped134114323mopp__ed
mopper126215003mopper__
moppers133412463mopper_s
mothered142310103mothered
ochered132610283_ochered
offered1436143_offered
opened94311863_o_pened
opposed1236123_opposed
ordered9108533_ordered
osiered837123_osiered
overed102216623_o_vered
pampered15229223pampered
papered122513163_papered
paupered13216933paupered
peered93819483__peered
pepperer1145273pepperer
plopped11288773plopp__ed
pondered126411293pondered
popeyed1535703po_peyed
popped104117813popp__ed
popper93615963popper__
poppers103414863popper_s
poppied11388983popp_ied
poppled11339233popp_led
portered112311533portered
pothered142311043pothered
pottered112311663pottered
powdered15256893powdered
powered132911643po_wered
prospered1446973prospered
rapiered1136053rapiered
rappeled1335003rappeled
repapered1445233repapered
rogered939553ro_gered
scuppered1643933scuppered
simpered1338253simpered
skippered1843433skippered
slobbered14144223slobbered
slopped123511443slopp__ed
sobered102912433so_bered
soldered1038153soldered
sopped114819903sopp__ed
speered103614813_speered
sphered133512313_sphered
spiered104412463_spiered
supered10316123_supered
syphered1755013syphered
tampered13279463tampered
tapered102612933_tapered
tempered13248213tempered
tochered1437913tochered
topped114617723topp__ed
topper103817603topper__
toppers113914603topper_s
toppled12348843topp_led
tottered9208703tottered
towered112911403to_wered
wondered13239943wondered

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.1561145455.1
2DLD Change Limit1461621897.51319454.5
3Display Results1891890.0802362.5
 (SQL Overall)1786911897.74923059.9
 
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.