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

316 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
shrimp1347876(None) 
scrimp125110581scrimp
shrimps14516751shrimps
shrimpy17415401shrimpy
chimp145216472ch_imp
crimp115615802_crimp
primp115615922_primp
scrim95419722scrim_
scrimps13517902scrimps
scrimpy16486132scrimpy
scrims104615932scrims
scrip96619192scri_p
shim95827842sh_im_
shims104422542sh_ims
ship95228232sh_i_p
shlump1345712shlump
shri76021692shri__
shriek134211102shriek
shrift12413542shrift
shrike134513242shrike
shrill94712302shrill
shrimped1634212shrimped
shrimper1544412shrimper
shrine94920052shrine
shrink134511732shrink
shris84221442shri_s
shrive125216952shrive
simp85228772s__imp
skimp135411312s_kimp
strip77524332stri_p
surimi839102surimi
thrip103012182thri_p
ashram1139053ashram_
ashrams1236653ashrams
atrip75315743atri_p
berime105317333berime
blimp115612943_blimp
brim85629373_brim_
brims94721623_brims
champ145017963ch_amp
chimb144813563ch_imb
chime125322593ch_ime
chimps155713663ch_imps
chip116726423ch_i_p
chirm125317063chirm_
chirms135113983chirms
chirp124717163ch_irp
chomp144815663ch_omp
chrism13710673chrism
chrisma1456823chrisma
chrisms1499143chrisms
chroma132912473chroma
chrome133214813chrome
chromo132811013chromo
chromy16309903chromy
chump145315443ch_ump
cramp115120693_cramp
crime94822693_crime
crimps124613453_crimps
crimpy15489393_crimpy
crisp95014623_crisp
crump115616423_crump
drip76223953_dri_p
frump126912563_frump
gimp96124043__gimp
gramp106218323_gramp
grim76929423_grim_
grime85021323_grime
grimy114312603_grimy
grip76127023_gri_p
grump105115313_grump
hemp115725623_h_emp
him86247653_h_im_
hims95230973_h_ims
hip86750433_h_i_p
hump116228723_h_ump
ihram10310183ihram_
ihrams1137173ihrams
imp76626973___imp
jimp155618463__jimp
limp88432493__limp
pimp106024903__pimp
prim85132203_prim_
prima95019343_prima
prime96525603_prime
primi95017403_primi
primo95017913_primo
primps124711823_primps
prims95425933_prims
ramp85934003__ramp
rim56052273__rim_
rime65138883__rime
rims65936303__rims
rimy96621283__rimy
rip56851303__ri_p
romp85926573__romp
rump86729083__rump
samp85733593s__amp
sari45444043sari__
sarin55239253sari_n
sarins63932623sarins
saris54544953sari_s
scamp115717313s_camp
schlump1643263schlump
schrik15206703schri_k
schriks16185743schriks
scram910621613scram_
scrams105216623scrams
scrap97120403scr_ap
scribe104613533scribe
scried95817303scried
scries85226823scries
scrimped1555313scrimped
scrimper1455753scrimper
scrimpit1444183scrimpit
scrips105316033scrips
script105717903script
scrive115414943scrive
scroop10299773scroop
scrum95418193scrum_
scrums104614253scrums
serial64625853serial
seriema938403seriema
series64540973series
serif84132133seri_f
serifs94017053serifs
serin55434443seri_n
serine65432673serine
sering74731813sering
serins64029673serins
serum75223473serum_
serums83916303serums
shaird10288703shaird
shairn9269063shairn
sham96436353sh_am_
shame105726703sh_ame
shammy16388503shammy
shams105829413sh_ams
sharia93116723shari_a
shariah132210533shariah
sharias102516003sharias
sharif122917113shari_f
sharifs13279903sharifs
sharing113723243sharing
sharp104922533sh_arp
shawm135316143shawm_
shawms14579563shawms
sheep105321523sh_eep
sheik122514653shei_k
sheikh16206993sheikh
sheiks132510013sheiks
sheila969843sheila
sherif122915233sheri_f
sheriff16287693sheriff
sherifs13299683sherifs
shied96125493sh_ied
shiel811023773sh_iel
shier85428943sh_ier
shies86136553sh_ies
shift114225133sh_ift
shill85325333sh_ill
shily115222013sh_ily
shimmy16306413shimmy
shin75634303sh_i_n
shine85533093sh_ine
shins85131043sh_ins
shiny115122143sh_iny
ships105123773sh_ips
shire84727133sh_ire
shires95225573shires
shirk124817843sh_irk
shirks134814123shirks
shirr84716923sh_irr
shirrs94413173shirrs
shirt84533893sh_irt
shirts94918333shirts
shirty124312553shirty
shist84829603sh_ist
shit76745933sh_i_t
shits84731163sh_its
shiv105721163sh_i_v
shiva115915003sh_iva
shive114423423sh_ive
shivs115018803sh_ivs
shlep104914833sh_lep
shlepp13366193shlepp
shlumps1434143shlumps
shlumpy1742863shlumpy
shmo95318093sh__mo
shop95629833sh__op
shoring112820063shoring
shrank13359123shrank
shred98125613shr_ed
shreds105613053shreds
shrew119720163shr_ew
shrewd136810773shrewd
shrews129313913shrews
shrieks14377673shrieks
shrieky17364803shrieky
shrieve13417683shrieve
shrifts1335963shrifts
shrikes144412393shrikes
shrills10389933shrills
shrilly13318553shrilly
shrimpers1633813shrimpers
shrimpier1643063shrimpier
shrimping1734063shrimping
shrined114112413shrined
shrines104618693shrines
shrinks14397913shrinks
shrived144712183shrived
shrivel13479403shrivel
shriven13379653shriven
shriver134712193shriver
shrives134416173shrives
shroff1538493shroff
shroud1038763shroud
shrove125412223shrove
shrub104814893shr_ub
shrubs11409213shrubs
shrug94512513shr_ug
shrugs10469163shrugs
shrunk13357063shrunk
shtick15308013shtick
shtik123210943shti_k
shtiks13297823shtiks
shying134211843shying
sim56553133s__im_
sima64730783s__ima
simps94719763s__imps
sims65737173s__ims
sip57656013s__i_p
siring75128313siring
sirup74014913sir_up
skim105322493s_kim_
skimo116312533s_kimo
skimps14488043s_kimps
skimpy17475723s_kimpy
skims114517183s_kims
skip105421743s_ki_p
slim66631953s_lim_
slime74925753s_lime
slims75423653s_lims
slimy105417423s_limy
slip67031733s_li_p
slump94816633s_lump
snip66424653s_ni_p
sori46039833sori__
soring74731883soring
sprier84119063sprier
sprig85617743spri_g
sprigs94814773sprigs
spring94526013spring
sprint84526793sprint
sprit76736403spri_t
sprite84421773sprite
sprits85122533sprits
spritz174714413spritz
sri35634003s_ri__
sris45434153s_ri_s
stamp95217363s_tamp
stime76521793s_time
stimy105114733s_timy
stirp76815503s_tirp
stomp95616663s_tomp
strap77925263str_ap
strep77120853str_ep
stria55723203stri_a
striae65422273striae
strick124813203strick
strict84821043strict
stride75420963stride
strife95318363strife
strike105619733strike
string75327563string
stripe85822443stripe
strips85719653strips
stript85222193stript
stripy115812743stripy
strive95020963strive
stroma84313073stroma
strop77422243str_op
strum75619443strum_
struma84313273struma
strums84716453strums
stump94616463s_tump
sump86331533s__ump
surimis938843surimis
swamp125015323s_wamp
swim96221393s_wim_
swims105514143s_wims
syrinx1637143syrinx
syrup103010963syr_up
threap11569663threap
threep115910113threep
thrice114311573thrice
thrift12412043thrift
thrill94910593thrill
thrips11299013thrips
thrive125313223thrive
thrum104713633thrum_
thrums11429123thrums
thump126211573th_ump
tramp96319773_tramp
trim65329513_trim_
trims75021473_trims
trip66830393_tri_p
tromp95815803_tromp
trump95615123_trump
unrip72012863unri_p
whim126220523wh_im_
whims134515333wh_ims
whip125521843wh_i_p
whomp155011323wh_omp
whump154910043wh_ump
wimp115521523__wimp

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 Limit1127163165.09322131.6
3Display Results3163160.0933397.8
 (SQL Overall)1786913165.32933531.8
 
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.