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

151 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
wampum1540605(None) 
wampums16314211wampums
wampus13499011wampus
ampul91110852_ampul
campus125213922campus
wammus13426732wammus
wamus105514682wam_us
album92312653_album
algum82711763_algum
alum65227613_a_lum
amour75014853_amour
amp77541023_amp__
amped104820513_amped
ample94720303_ample
amply125012913_amply
amps86230343_amp_s
ampule10710613_ampule
ampuls1098893_ampuls
amu58237323_am_u_
amus65529613_am_us
amylum1344693_amylum
arum66129033_a_rum
aurum7614963_aurum
awmous1157713awmous
barium10313513barium
cadmium1446113cadmium
caecum1238183caecum
cambium1537323cambium
camp106336453camp__
camped134720233camped
camper124722213camper
campi116217783camp_i
campo115219763camp_o
campos125217953campos
campout13412853campout
camps116330263camp_s
campy145116183camp_y
caput9823983ca_put
carpus105514303carpus
dadgum1134583dadgum
damp96228843damp__
damped124315583damped
dampen114310593dampen
damper114117753damper
damply14337893damply
damps105220413damp_s
datum8310633da_tum
dumdum1244523dumdum
famous11412393famous
fanum10313443fa_num
gamp98833213gamp__
gamps105323713gamp_s
gamut8322983gam_ut
gaum75726423ga__um
grampus12356313grampus
hamaul114210873hamaul
hammam12419333hammam
hamper134518653hamper
iambus10468903iambus
imaum9139643_imaum
kalium1239473kalium
kaput11717063ka_put
labium10410243labium
labrum1057423labrum
lamp86233823lamp__
lampad114510033lampad
lampas106615953lampas
lamped114017543lamped
lamps95624833lamp_s
larum74317973la_rum
magnum1136733magnum
mamluk1434743mamluk
mum76643613__m_um
oakum1177313oa_kum
omasum1035503omasum
osmium1036573osmium
pablum1237503pablum
palpus104210283palpus
pampa114913423pamp_a
pampas124913993pampas
pamper124316663pamper
pappus9408373pappus
pompom1436493pompom
radium93513293radium
ramous8417113ramous
ramp85934003ramp__
ramped114617903ramped
ramps96224633ramp_s
ramus76418283ram_us
rumpus10458893rumpus
sacrum103910143sacrum
sagum8512873sa_gum
sambur10469503sambur
samp85733593samp__
sampan102511893sampan
sample104215013sample
samps96124673samp_s
swamp125015323swamp__
swamped15498443swamped
swamper14349313swamper
swamps135910263swamp_s
swampy16437233swamp_y
talcum1036953talcum
tambur10358713tambur
tamp86133003tamp__
tampan102512323tampan
tamped114317043tamped
tamper104618513tamper
tampon102911233tampon
tamps95524083tamp_s
vacuum1334833vacuum
vamp115521543vamp__
vamped144211013vamped
vamper134212653vamper
vamps125415483vamp_s
vampy15539403vamp_y
waeful1238123waeful
walkup1534193walkup
walnut939433walnut
walrus956433walrus
wamble134415753wamble
wambly16388663wambly
wame95035483wam__e
wameful1535673wameful
wames106432803wam_es
wampish1777293wampish
wampuses1534113wampuses
wangun1037103wangun
wap86553373wa_p__
wapped144416473wapped
waps96642083wa_p_s
warm95935673wa__rm
warmup1335343warmup
warmups1433813warmups
warp95635003warp__
warped124816413warped
warper114015583warper
warps107126423warp_s
washup1435323washup
wasp95626853wasp__
wasps106714693wasp_s
waspy135410993wasp_y
wauk115220593wa__uk
waul76927313wa__ul
waur76819903wa__ur
wimp115521523wimp__
wimped144211513wimped
wimple133611363wimple
wimps125213803wimp_s
wimpy155911923wimp_y
yamun10419273yam_un

Search took 6 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 Filter1786911127160.1431249587.4
2DLD Change Limit1127161515.29621283.2
3Display Results1511510.0463282.6
 (SQL Overall)1786911515.48532578.1
 
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.