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

253 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
scrimps1351790(None) 
crimps124613451_crimps
scrimp125110581scrimp_
scrimpy16486131scrimpy
scrims104615931scrim_s
scrips105316031scri_ps
shrimps14516751shrimps
chimps155713662_chimps
cramps125615562_cramps
crimes105521582_crimes
crimp115615802_crimp_
crimpy15489392_crimpy
crisps104411512_crisps
crumps124514342_crumps
primps124711822_primps
scamps125014172sc_amps
scrams105216622scram_s
scraps106017242scr_aps
scribes113713202scribes
scries85226822scri_es
scrim95419722scrim__
scrimped1555312scrimped
scrimper1455752scrimper
scrimpers1554632scrimpers
scrimpit1444182scrimpit
scrip96619192scri_p_
script105717902scri_pt
scripts11509372scripts
scrives124414272scrives
scroops11288242scroops
scrums104614252scrum_s
shrimp13478762shrimp_
shrimpy17415402shrimpy
simps94719762s__imps
skimps14488042s_kimps
strips85719652stri_ps
surimis938842surimis
ascribes1246193ascribes
becrimes1467073becrimes
berimes115216643berimes
blimps12588153_blimps
brims94721623_brim_s
camps116330263_c_amps
champs154915683_champs
chimbs153910303_chimbs
chimes134922573_chimes
chimp145216473_chimp_
chips125721253_chi_ps
chirps135414003_chirps
chomps155112223_chomps
chumps154313823_chumps
clamps124515083_clamps
climbs12498723_climbs
climes104720003_climes
clips96018303_cli_ps
clomps125212233_clomps
clumps1215314643_clumps
comps115526053_c_omps
cramp115120693_cramp_
crampy154710993_crampy
crams96229153_cram_s
craps95328643_cr_aps
creeps104213623_creeps
cremes104517993_cremes
cribs94516743_cri_bs
cricks144316053_cricks
criers83918583_criers
cries75438403_cri_es
crime94822693_crim_e
crimped143910763_crimped
crimper136510423_crimper
crimpers14318933_crimpers
crimple13408693_crimple
crimples14308963_crimples
cripe95521143_cri_pe
cripes105120873_cripes
cris66233433_cri__s
crises84529433_crises
crisis83716343_crisis
crisp95014623_crisp_
crispy13478563_crispy
crits75527573_cri_ts
crops96125233_cr_ops
croups104312553_croups
crumbs12409233_crumbs
crump115616423_crump_
drips85417233_dri_ps
frumps13479783_frumps
gimps105915203__gimps
gramps114114273_gramps
grimes94619033_grimes
grips85520133_gri_ps
grumps114510573_grumps
imps86221113___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
sacrings11278923sacrings
sacrists1039563sacrists
sacrums11388043sacrum_s
samps96124673s__amps
sarins63932623sari_ns
saris54544953sari__s
scalps104315233sc_alps
scamp115717313sc_amp_
scampi12469103sc_ampi
scams94423973sc_am_s
scarious10610203scarious
scarps104718603sc_arps
scaups105411933sc_aups
schemas1468163schemas
schemes1489663schemes
schisms1437173schisms
schists1248543schists
schizos21115423schizos
schleps1445483schleps
schlumps1742743schlumps
schmos13379153sc_hmos
schnaps1443703schnaps
schriks16185743schri_ks
scions82612233sc_ions
scoops105414363sc_oops
scops95820193sc__ops
scrags95713803scr_ags
scraichs1543993scraichs
scraighs1443633scraighs
scram910621613scram__
scrap97120403scr_ap_
scrape105917573scr_ape
scrapes116217663scrapes
scrappy16234473scrappy
scrawls12177273scrawls
screaks13469353screaks
screams114810613screams
screeds106210283screeds
screens95212173screens
screes85023963scr_ees
screws115513883scr_ews
screwups1542283screwups
scribal1137963scribal
scribe104613523scri_be
scribed124510643scribed
scriber113910963scriber
scribers12307953scribers
scried95817303scri_ed
scrieve12448333scrieve
scrieves13387613scrieves
scrimpier1554243scrimpier
scrimpiest1643743scrimpiest
scrimpily1842553scrimpily
scrimping1634953scrimping
scrive115414943scri_ve
scrived134511113scrived
scrods94111603scr_ods
scrolls938063scrolls
scroop10299773scroop_
scrubs104210313scr_ubs
scruffs1554173scruffs
scrum95418193scrum__
sculps104611753sc_ulps
scums95017423sc_um_s
scups95316653sc__ups
serials73919743serials
seriemas1047193seriemas
series64540973seri_es
serifs94017053seri_fs
serines74229543serines
serins64029673seri_ns
serious73616283serious
serums83916303serum_s
shims104422543s_him_s
ships105123773s_hi_ps
shlumps1434143shlumps
shrieks14377673shrieks
shrifts1335963shrifts
shrikes144412393shrikes
shrills10389933shrills
shrimped1634213shrimped
shrimper1544413shrimper
shrimpers1633813shrimpers
shrines104618693shrines
shrinks14397913shrinks
shris84221443shri__s
shrives134416173shrives
simas75727553s__imas
simp85228773s__imp_
sims65737173s__im_s
sips65740103s__i_ps
sirups83710533sir_ups
skimos12548803s_kimos
skimp135411313s_kimp_
skimpy17475723s_kimpy
skims114517183s_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
stirps85011813s_tirps
stomps105612833s_tomps
straps87721783str_aps
streps86218063str_eps
stricks134310693stricks
strides84520393strides
strifes104716583strifes
strikes114719093strikes
strings84617133strings
strip77524333stri_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
thrips11299013thri_ps
tramps105114453_tramps
trims75021473_trim_s
trips74923363_tri_ps
tromps104911703_tromps
trumps104611883_trumps
unrips8199453unri_ps
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.1401276364.3
2DLD Change Limit1340272536.95319276.1
3Display Results2532530.0763328.9
 (SQL Overall)1786912537.16924925.5
 
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.