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

134 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
shrimpy1741540(None) 
scrimpy16486131scrimpy
shrimp13478771shrimp_
shrimps14516751shrimps
crimpy15489392_crimpy
scrimp125110582scrimp_
scrimps13517902scrimps
shimmy16306412sh_immy
shlumpy1742862shlumpy
shrieky17364802shrieky
shrilly13318562shrilly
shrimped1634212shrimped
shrimper1544412shrimper
skimpy17475722s_kimpy
stripy115812742stri_py
champy18509613ch_ampy
chimp145216473ch_imp_
chimps155713663ch_imps
chippy18437613ch_ippy
chirpy16498913ch_irpy
christy1536623christy
chromy16309903chrom_y
crampy154710993_crampy
crimp115615803_crimp_
crimps124613453_crimps
crispy13478563_crispy
drippy14445653_drippy
frumpy16466883_frumpy
gimpy135212233__gimpy
grimly12459933_grimly
grimy114312603_grim_y
grippy14447763_grippy
gripy115115253_gri_py
grumpy14498153_grumpy
hempy154912763_h_empy
hippy155112793_h_ippy
humpy155115673_h_umpy
jimpy195210823__jimpy
primly13439623_primly
primp115615923_primp_
primps124711823_primps
rimy96621283__rim_y
schlumpy2041873schlumpy
scrappy16234473scrappy
scrim95419743scrim__
scrimped1555313scrimped
scrimper1455763scrimper
scrimpily1842553scrimpily
scrimpit1444183scrimpit
scrims104615933scrim_s
scrip96619193scri_p_
scrips105316033scri_ps
script105717903scri_pt
shammy16388503sh_ammy
shamoy14379913sh_amoy
sharpy145211033sh_arpy
shifty15409263sh_ifty
shily115222013sh_i_ly
shim95827863sh_im__
shims104422553sh_im_s
shindy13449323sh_indy
shinny124810783sh_inny
shiny115122143sh_i_ny
ship95228243sh_i_p_
ships105123773sh_i_ps
shirty124312563sh_irty
shitty124110063sh_itty
shlump1345713shlump_
shlumps1434143shlumps
shri76021703shri___
shriek134211103shri_ek
shrieks14377673shrieks
shrieve13417683shrieve
shrift12413543shri_ft
shrifts1335963shrifts
shrike134513243shri_ke
shrikes144412393shrikes
shrill94712303shri_ll
shrills10389933shrills
shrimpers1633813shrimpers
shrimpier1643063shrimpier
shrimping1734063shrimping
shrine94920053shri_ne
shrined114112413shrined
shrines104618693shrines
shrink134511733shri_nk
shrinks14397913shrinks
shris84221453shri__s
shrive125216953shri_ve
shrived144712183shrived
shrivel13479403shrivel
shriven13379653shriven
shriver134712193shriver
shrives134416173shrives
shrubby1742363shrubby
shticky19344473shticky
simp85228773s__imp_
simply133010523s__imply
simps94719763s__imps
sirupy11377053sir_upy
skimp135411323s_kimp_
skimps14488043s_kimps
slimly11408903s_limly
slimpsy1463333s_limpsy
slimsy11407723s_limsy
slimy105417423s_lim_y
slippy1375843s_lippy
snippy1374843s_nippy
spriggy14374213spriggy
springy13359663springy
stimy105114743s_tim_y
strappy14205263strappy
stringy114111073stringy
strip77524343stri_p_
stripe85822443stri_pe
strips85719653stri_ps
stript85222193stri_pt
stroppy14205093stroppy
stumpy13458133s_tumpy
surimi839103surim_i
surimis938843surimis
swampy16437233s_wampy
swimmy16234353s_wimmy
syrupy14285823syr_upy
thrifty1634193thrifty
thrip103012183thri_p_
thrips11299013thri_ps
thrummy1742173thrummy
trampy13499253_trampy
trimly114410893_trimly
trippy13457803_trippy
whimsy17375223wh_imsy
whippy19385843wh_ippy
wimpy155911923__wimpy

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 Filter1786911340270.780229091.0
2DLD Change Limit1340271346.97019229.1
3Display Results1341340.0462913.0
 (SQL Overall)1786911347.79622920.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.