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

207 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
dampish156766(None) 
dumpish15116111dumpish
vampish1766281vampish
wampish1777291wampish
apish105116632_a_pish
aspish114810332_aspish
dampest12411042dampest
damping133414002damping
damps105220412damp_s_
danish101513792da_nish
darkish1537942darkish
famish14311842fam_ish
impish13499192_impish
lumpish14127382lumpish
rammish1437562rammish
raspish1298102raspish
rompish1436692rompish
scampish1744892scampish
swampish1844172swampish
trampish1535652trampish
waspish1586922waspish
wimpish1765692wimpish
admonish1446033admonish
aguish1059283_aguish
ambush1336113_ambush
amis66445323_am_is_
amiss75823073_am_iss
amping114317573_amping
amps86230343_amp_s_
aspis74618143_aspis_
babyish1736513babyish
baldish1339503baldish
banish111416043ba_nish
batfish1558683batfish
beamish14259293beam_ish
blimpish1743723blimpish
caddish143810133caddish
cambism1538033cambism
cambist13312113cambist
camisa103114323cam_isa
camise103319633cam_ise
campi116217783campi__
campier133313273campier
campiest142212143campiest
campily1638273campily
camping143118973camping
campion133011413campion
campos125217953campos_
camps116330263camp_s_
campus125213923campus_
carlish12312773carlish
catfish1559023catfish
cattish12410723cattish
clumpish17164893clumpish
crampfish2142593crampfish
dadaism1136443dadaism
dadaist9310103dadaist
dais57040703da__is_
daisy95915313da__isy
damans94715983damans_
damars93815003damars_
damask1335843dam_ask
dames85435853dam_es_
damming133812743damming
dammit11311133dammi_t
damnify1643453damnify
damning114211633damning
damns84916923dam_ns_
damp96228843damp___
damped124315583damp_ed
dampen114310593damp_en
dampens12348563dampens
damper114117753damp_er
dampers123915693dampers
dampings14377523dampings
damply14337893damp_ly
dampness1336073dampness
dams77444373dam__s_
dandyish1644723dandyish
dapping133714793dapping
daps77239163da_p_s_
dash87031633da___sh
dashis104414393dashis_
deafish1438533deafish
dealfish1545503dealfish
delish105215613d_elish
demise94618323dem_ise
demolish1447833demolish
dervish1436983dervish
despise1038683despise
diminish14127523diminish
dish86328333d___ish
dogfish15226763dogfish
doggish13237533doggish
dollish11610093dollish
doltish11118733doltish
donnish11187633donnish
dovish1338103d_ovish
draffish1844553draffish
dronish1138913dronish
drumfish1743503drumfish
dryish1336323d_ryish
dudish1148313d_udish
dullish1148743dullish
dumpier12409653dumpier
dumpiest1338743dumpiest
dumpily1566233dumpily
dumping133712913dumping
dumps105220103dump_s_
duncish1335793duncish
duskish1535183duskish
dwarfish1843783dwarfish
faddish15359003faddish
fairish1338993fairish
fattish1359263fattish
foppish1735103foppish
frumpish1843503frumpish
gamps105323713gamp_s_
garfish14179203garfish
garish104516923ga_rish
garnish111610843garnish
gawkish1835833gawkish
grumpish1643763grumpish
hagfish17227613hagfish
haggish15207473haggish
haimish1537753haimish
harpist12312363harpist
hashish1238353hashish
hawkish2036553hawkish
hippish1736183hippish
impis96213853_impis_
jadish17319903ja_dish
kaddish16317973kaddish
laddish12299723laddish
ladyish14287823ladyish
lampas106615953lampas_
lamping123116003lamping
lampion11278303lampion
lamps95624833lamp_s_
lapis76223153la_pis_
largish1138603largish
larkish1439083larkish
latish92416173la_tish
lavish124112983la_vish
lazyish22265853lazyish
lumpfish1843053lumpfish
maddish14289483maddish
maidish13239553maidish
mannish121710693mannish
marish114319053ma_rish
mawkish1935823mawkish
mopish134311593_mopish
oafish121311723oa_fish
oarfish13158613oarfish
palish114718273pa_lish
pampas124913993pampas_
panfish15229973panfish
papism122211513pa_pism
papist102618753pa_pist
parish115022353pa_rish
pish96127913___pish
plumpish17164733plumpish
popish133812113_popish
radish103516913ra_dish
raffish1658843raffish
rakish134313963ra_kish
rampike1536603rampike
ramping123316873ramping
rampion11298583rampion
ramps96224633ramp_s_
rankish14510383rankish
rapist82520673ra_pist
ratfish1338773ratfish
rattish10510823rattish
ravish123414033ra_vish
rawish123012913ra_wish
saltish10312163saltish
samps96124673samp_s_
sawfish1637683sawfish
snappish1545243snappish
tallish103313583tallish
tamis76728733tam_is_
tamping122815813tamping
tampion11298663tampion
tamps95524083tamp_s_
tannish101610573tannish
tapis75028863ta_pis_
tarnish101611873tarnish
tartish101512633tartish
uppish1336633_uppish
vampier14308233vampier
vampiest15237653vampiest
vamping152810233vamping
vampire14296673vampire
vampirish1952473vampirish
vampishly2243113vampishly
vamps125415483vamp_s_
vanish121513213va_nish
varnish13169533varnish
waggish15207073waggish
waifish1637703waifish
wampished2042803wampished
wampishes1944303wampishes
wampus13499013wampus_
warmish1538373warmish
wispish1575643wispish
zanyish2235903zanyish

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272075.82623005.0
3Display Results2072070.0633285.7
 (SQL Overall)1786912076.29528386.2
 
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.