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

255 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
shrimps1451675(None) 
scrimps13517901scrimps
shrimp13478771shrimp_
shrimpy17415401shrimpy
chimps155713662ch_imps
crimps124613452_crimps
primps124711822_primps
scrimp125110582scrimp_
scrimpy16486132scrimpy
scrims104615932scrim_s
scrips105316032scri_ps
shims104422552sh_im_s
ships105123772sh_i_ps
shlumps1434142shlumps
shrieks14377672shrieks
shrifts1335962shrifts
shrikes144412392shrikes
shrills10389932shrills
shrimped1634212shrimped
shrimper1544412shrimper
shrimpers1633812shrimpers
shrines104618692shrines
shrinks14397912shrinks
shris84221452shri__s
shrives134416172shrives
simps94719762s__imps
skimps14488042s_kimps
strips85719652stri_ps
surimis938842surimis
thrips11299012thri_ps
ashrams1236653ashram_s
berimes115216643berimes
blimps12588153_blimps
brims94721623_brim_s
champs154915683ch_amps
chimbs153910303ch_imbs
chimes134922573ch_imes
chimp145216473ch_imp_
chips125721253ch_i_ps
chirms135113983chirm_s
chirps135414003ch_irps
chomps155112223ch_omps
chrisms1499143chrisms
chromas142512693chromas
chromes142914933chromes
chromos142610273chromos
chumps154313823ch_umps
cramps125615563_cramps
crimes105521583_crimes
crimp115615803_crimp_
crimpy15489393_crimpy
crisps104411513_crisps
crumps124514343_crumps
drips85417233_dri_ps
frumps13479783_frumps
gimps105915203__gimps
gramps114114273_gramps
grimes94619033_grimes
grips85520133_gri_ps
grumps114510573_grumps
hemps126917333_h_emps
hims95230973_h_im_s
hips96433703_h_i_ps
humps126322803_h_umps
ihrams1137173ihram_s
imps86221123___imps
limps95522673__limps
pimps114616983__pimps
primas104418103_primas
primes104225263_primes
primos104514423_primos
primp115615923_primp_
prims95425933_prim_s
primus103712173_primus
ramps96224633__ramps
rimes75634543__rimes
rims65936303__rim_s
rips66237433__ri_ps
romps94617543__romps
rumps95922293__rumps
samps96124673s__amps
sarins63932623sari_ns
saris54544953sari__s
scamps125014173s_camps
schlumps1742743schlumps
schriks16185743schri_ks
scrams105216623scram_s
scraps106017243scr_aps
scribes113713203scribes
scries85226823scri_es
scrim95419743scrim__
scrimped1555313scrimped
scrimper1455763scrimper
scrimpers1554643scrimpers
scrimpit1444183scrimpit
scrip96619193scri_p_
script105717903scri_pt
scripts11509373scripts
scrives124414273scrives
scroops11288253scroops
scrums104614253scrum_s
serials73919743serials
seriemas1047193seriemas
series64540973seri_es
serifs94017053seri_fs
serines74229543serines
serins64029673seri_ns
serious73616283serious
serums83916303serum_s
shairds11216263shairds
shairns10276783shairns
shamas113717943sh_amas
shames114726223sh_ames
shammas14358723shammas
shammes144312833shammes
shammos14307203shammos
shamos114216983sh_amos
shams105829413sh_am_s
shamus114112813sh_amus
shariahs14206393shariahs
sharias102516003shari_as
sharifs13279903shari_fs
sharps115516083sh_arps
shawms14579563shawm_s
sheikhs17233993sheikhs
sheiks132510013shei_ks
sheilas1059403sheilas
sheriffs17253923sheriffs
sherifs13299683sheri_fs
shiels95418923sh_iels
shiers94921753sh_iers
shies86136553sh_i_es
shifts124412943sh_ifts
shills94519613sh_ills
shim95827863sh_im__
shimmy16306413sh_immy
shines95028913sh_ines
shins85131043sh_i_ns
ship95228243sh_i_p_
shires95225573sh_ires
shirks134814123sh_irks
shirrs94413173sh_irrs
shirts94918343sh_irts
shists96515113sh_ists
shits84731173sh_i_ts
shivas124512413sh_ivas
shives124921413sh_ives
shivs115018803sh_i_vs
shlepps14394833shlepps
shleps114710333sh_leps
shlump1345713shlump_
shlumpy1742863shlumpy
shnapps1463343shnapps
shnaps1148083sh_naps
shops104222903sh__ops
shorings12269483shorings
shreds105613053shr_eds
shrews129313923shr_ews
shri76021703shri___
shriek134211103shri_ek
shrieky17364803shrieky
shrieve13417683shrieve
shrieves14297093shrieves
shrift12413543shri_ft
shrike134513243shri_ke
shrill94712303shri_ll
shrilly13318563shrilly
shrimpier1643063shrimpier
shrimpiest1743323shrimpiest
shrimping1734063shrimping
shrine94920053shri_ne
shrined114112413shrined
shrink134511733shri_nk
shrive125216953shri_ve
shrived144712183shrived
shrivel13479403shrivel
shrivels14376443shrivels
shriven13379653shriven
shriver134712193shriver
shrivers14419103shrivers
shroffs1634363shroffs
shrouds1136023shrouds
shrubs11409213shr_ubs
shrugs10469163shr_ugs
shticks16356963shticks
shtiks13297833shti_ks
simas75727553s__imas
simp85228773s__imp_
sims65737173s__im_s
sips65740103s__i_ps
sirups83710533sir_ups
skimos12548803s_kimos
skimp135411323s_kimp_
skimpy17475723s_kimpy
skims114517193s_kim_s
skips115616603s_ki_ps
slimes84722043s_limes
slimpsy1463333s_limpsy
slims75423653s_lim_s
slips76023723s_li_ps
slumps104313583s_lumps
snips75818013s_ni_ps
sorings83817253sorings
sorites73825243sorites
sprigs94814773spri_gs
springs104415923springs
sprints94113773sprints
sprites94220333sprites
sprits85122533spri_ts
sris45434153s_ri__s
stamps105614023s_tamps
stimes85920573s_times
stirps85011823s_tirps
stomps105612833s_tomps
straps87721783str_aps
streps86218063str_eps
stricks134310693stricks
strides84520393strides
strifes104716583strifes
strikes114719093strikes
strings84617133strings
strip77524343stri_p_
stripe85822443stri_pe
stripes95320573stripes
stript85222193stri_pt
stripy115812743stri_py
strives104119373strives
strops86220383str_ops
strumas9419833strumas
strums84716453strum_s
stumps104912283s_tumps
sumps95023433s__umps
surimi839103surim_i
swamps135910263s_wamps
swims105514143s_wim_s
syrups11277953syr_ups
threaps12488643threaps
threeps12687043threeps
thrifts1335523thrifts
thrills10398783thrills
thrip103012183thri_p_
thrives134611713thrives
thrums11429123thrum_s
thumps13449353th_umps
tramps105114453_tramps
trims75021473_trim_s
trips74923363_tri_ps
tromps104911703_tromps
trumps104611883_trumps
unrips8199453unri_ps
whims134515333wh_im_s
whips134917083wh_i_ps
whomps16457603wh_omps
whumps16427093wh_umps
wimps125213803__wimps

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.423422437.4
2DLD Change Limit1340272556.75019855.9
3Display Results2552550.0803187.5
 (SQL Overall)1786912557.25324636.8
 
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.