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

202 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
scrimper145576(None) 
crimper136510421_crimper
scrimped1555311scrimped
scrimpers1554641scrimpers
scrimpier1554241scrimpier
shrimper1544411shrimper
crimmer133310772_crimmer
crimped143910762_crimped
crimpers14318932_crimpers
crimpier14287322_crimpier
crisper113511052_crisper
scamper134613162sc_amper
scraper114513422scr_aper
scrapper1466972scrapper
scriber113910972scri_ber
scrimp125110582scrimp__
scrimpit1444182scrimpit
scrimps13517902scrimp_s
scrimpy16486132scrimp_y
scripter12137782scripter
shrimped1634212shrimped
shrimpers1633812shrimpers
shrimpier1643062shrimpier
simper103616292s__imper
striper94514792stri_per
stripper1247122stripper
acrider1038623acri_der
brimmer13348803_brimmer
camper124722213_c_amper
champer163813413_champer
chimer135517203_chim_er
chipper163912583_chipper
chirper14359963_chirper
chomper163810073_chomper
clamper134012993_clamper
climber13449133_climber
clipper133710323_clipper
crammer134010963_crammer
cramped144712183_cramped
crampier14288903_crampier
crapper133913193_crapper
creeper11339983_creeper
cribber13367663_cribber
crier74724463_cri__er
crime94822693_crim_e_
crimes105521583_crim_es
crimmers14298543_crimmers
crimp115615803_crimp__
crimple13408693_crimple
crimpled15366933_crimpled
crimples14308963_crimples
crimps124613453_crimp_s
crimpy15489393_crimp_y
cringer103514243_cringer
cripe95521143_cri_pe_
cripes105120873_cri_pes
crippler14826713_crippler
crisped124010103_crisped
crispen11348203_crispen
crispers12309433_crispers
crispier12297253_crispier
critter94113033_critter
cropper133312963_cropper
crumber13339643_crumber
crumped144311223_crumped
crumpet133711063_crumpet
crupper13338563_crupper
dripper12349233_dripper
grimier103210433_grimier
grimmer123510093_grimmer
griper94114613_gri_per
gripper124410713_gripper
jimper17389863__jimper
krimmer15376873_krimmer
limper104117853__limper
lorimer937753lorim_er
primer105118683_prim_er
primmer134310163_primmer
primped14479153_primped
rimer75429243__rim_er
rimier83916273__rimier
rimmer103516033__rimmer
riper74328403__ri_per
ripper103518653__ripper
romper104213683__romper
scalper113912923sc_alper
scammer133611973sc_ammer
scamped144711963sc_amped
scampers143611033sc_ampers
scarier94017873scari__er
scarifier1446653scarifier
scarper114814823sc_arper
scauper11379453sc_auper
schemer1477963schem_er
schiller13296473schiller
schizier2234063schizier
schmeer1475363sc_hmeer
scimiter1236143sc_imiter
scooper113812033sc_ooper
scorifier1445413scorifier
scrambler15165043scrambler
scramjet1945033scramjet
scrammed1555003scrammed
scrape105917573scr_ape_
scraped124313133scr_aped
scrapers125510533scr_apers
scrapes116217663scr_apes
scrapped1556533scrapped
scrappers1545863scrappers
scrappier1544433scrappier
scrawler1345893scrawler
screamer12267883screamer
screener1037573screener
screwer124410073scr_ewer
screwier1346433screwier
scribbler15164223scribbler
scribe104613533scri_be_
scribed124510643scri_bed
scribers12307963scri_bers
scribes113713203scri_bes
scried95817303scri__ed
scries85226823scri__es
scrieve12448333scrieve_
scrieved14366203scrieved
scrieves13387613scrieves
scrim95419743scrim___
scrimmager1751913scrimmager
scrimpiest1643753scrimpiest
scrimpily1842553scrimpily
scrimping1634953scrimping
scrims104615933scrim__s
scrip96619193scri_p__
scrips105316033scri_p_s
script105717903scri_p_t
scripted13117553scripted
scripters13116683scripters
scripts11509373scri_pts
scrive115414943scri_ve_
scrived134511113scri_ved
scrivener1443113scrivener
scrives124414273scri_ves
scrooped1356403scrooped
scrubber1434123scrubber
scrummed1554313scrummed
scummer13398753sc_ummer
scummier1445083scummier
scupper1367423sc_upper
shimmer143310873s_himmer
shipper143514043s_hipper
shrieker15265653shrieker
shriller1136823shriller
shrimp13478773shrimp__
shrimps14516753shrimp_s
shrimpy17415403shrimp_y
shrinker15236363shrinker
shriver134712193shri_ver
simmer104115353s__immer
simpers113014123s__impers
simpler112910863s__impler
sipper103920993s__ipper
skimmer15327533s_kimmer
skimped16256223s_kimped
skimpier1634293s_kimpier
skipper15339573s_kipper
slimier93212013s_limier
slimmer114211343s_limmer
slipper113712983s_lipper
sniper84413643s_ni_per
snipper113911333s_nipper
sprier84119063spri__er
sprigger12366503sprigger
springer113311753springer
sprinter103810813sprinter
spritzer1944563spritzer
stamper113714403s_tamper
stomper114111233s_tomper
strapper1258093strapper
stricter1039423stricter
strider84315723stri_der
striker113714173stri_ker
stringer93812943stringer
stripe85822443stri_pe_
striped105214363stri_ped
stripers103911593stri_pers
stripes95320573stri_pes
stripier1058863stripier
stripped1357093stripped
strippers1355773strippers
striver104315203stri_ver
stropper1247763stropper
strummer1234783strummer
strumpet1256033strumpet
stumper113610093s_tumper
surmiser1036763surmiser
swamper14349313s_wamper
swimmer14297653s_wimmer
tramper113812163_tramper
trimer85717153_trim_er
trimmer113610833_trimmer
tripper113711923_tripper
unriper9188283unri_per
whimper17297723_whimper

Search took 9 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 Filter1786911461620.656272394.8
2DLD Change Limit1461622027.93618417.6
3Display Results2022020.0633206.3
 (SQL Overall)1786912028.65520646.0
 
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.