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

170 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
skimpier163429(None) 
crimpier14287322crimpier
gimpier12247942_gimpier
scrimpier1554242scrimpier
shrimpier1643062shrimpier
simper103616292s_imp_er
simpler112910862s_impler
skiddier1464192skiddier
skimmer15327532skim_mer
skimped16256222skimp_ed
skimpiest1734502skimpiest
skimpily1963052skimpily
skimping17306242skimping
skinnier1264892skinnier
skipper15339572ski_pper
slimier93212012slim_ier
slimpsier1343022slimpsier
slimsier1085212slimsier
slippier1256532slippier
snippier1255792snippier
stumpier1255882stumpier
swampier1544592swampier
swimmier15174312swimmier
wimpier14248052_wimpier
bumpier13359203_bumpier
campier133313273_campier
chippier17297673chippier
chirpier15276303chirpier
clumpier1435583clumpier
crampier14288903crampier
crimper136510423crimp_er
crispier12297253crispier
dimplier1336673_dimplier
dippier123111393_dippier
drippier1385043drippier
dumpier12409653_dumpier
flimsier1344133flimsier
frumpier1534173frumpier
glimpser1342663glimpser
glumpier1334873glumpier
grimier103210433grim_ier
gripier103210323gri_pier
grippier1355203grippier
grumpier1334803grumpier
hempier14319003_hempier
hippier143212103_hippier
humpier143110723_humpier
jimper17389863_jimp_er
jumpier18317943_jumpier
kickier12349053_kickier
kinkier10319433_kinkier
kipper143414213_ki_pper
limbier11349113_limbier
limier83518723_lim_ier
limper104117853_limp_er
limpsier1234433_limpsier
lippier112710573_lippier
lumpier113410143_lumpier
nippier11319833_nippier
pimplier1445413_pimplier
pipier104913983_pi_pier
quippier2133773quippier
rimier83916273_rim_ier
sampler113212013s_ampler
sappier113613113s_appier
scamper134613163scamp_er
scampies1439323scampies
scimiter1236143scimiter
scrimper1455763scrimp_er
scummier1445083scummier
seamier93114633seam_ier
seemlier1035193seemlier
seepier92912013s_eepier
shiftier1436343shiftier
shimmer143310873shim_mer
shimmied16294983shimmied
shimmies15287803shimmies
shinier104113143shi_nier
shipper143514043shi_pper
shirtier1137943shirtier
shittier1137313shittier
shrimper1544413shrimp_er
silkier114411643s_ilkier
sillier74017593s_illier
siltier73413863s_iltier
simmer104115353s_im_mer
simperer1237173s_imperer
simpers113014123s_imp_ers
simple104315173s_imple_
simples113014943s_imples
simplex18256393s_implex
sipper103920993s_i_pper
sirupier1034303sirupier
sissier73711363s_issier
sizier1514813393s_i_zier
skankier11184883skankier
skidder1365733ski_dder
skier95119593sk___ier
skijorer1942143skijorer
skimmed16306053skim_med
skimmers16296463skim_mers
skimming17286273skimming
skimp135411323skimp___
skimpiness1842863skimpiness
skimps14488043skimp__s
skimpy17475723skimp__y
skinker10319443ski_nker
skinner11348093ski_nner
skipped16358413ski_pped
skippers16318203ski_ppers
skippet15288463ski_ppet
skipping17297603skipping
skirter11338483ski_rter
skitter113810403ski_tter
skiver134612103ski__ver
skivvied1971813skivvied
skivvies18112883skivvies
skunkier11174283skunkier
sleepier1036783sleepier
slimmer114211343slim_mer
slinkier12206933slinkier
slipper113712983sli_pper
slittier837003slittier
sloppier1255703sloppier
slummier1235473slummier
smirkier1444433smirkier
snappier1266213snappier
sniffier14356643sniffier
sniper84413643sni_p_er
snipper113911333sni_pper
snoopier10177273snoopier
soapier93411713s_oapier
soppier112711583s_oppier
soupier93111753s_oupier
spicier115112463spi_cier
spier75728033s___pier
spiffier16255883spiffier
spikier13369983spi_kier
spinier93715163spi_nier
spirier93214073spi_rier
spumier1137903spum_ier
stamper113714403stamp_er
stemmier1245253stemmier
stickier14229763stickier
stillier868823stillier
stimied10310623stim_ied
stimies9316563stim_ies
stingier9279123stingier
stinkier12278543stinkier
stippler1235543stippler
stomper114111233stomp_er
stripier1058863stripier
stumper113610093stump_er
sumpter1138873s_umpter
swamper14349313swamp_er
sweepier1355493sweepier
swimmer14297653swim_mer
swingier12267003swingier
swirlier1135213swirlier
swishier1434563swishier
swoopier13175143swoopier
syrupier1343053syrupier
tippier113210543_tippier
trampier12318243trampier
trippier1246623trippier
vampier14308233_vampier
whimper17297723whimp_er
whippier18265823whippier
wispier12249403_wispier
zippier20308193_zippier

Search took 7 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.420425454.8
2DLD Change Limit1461621706.19023612.6
3Display Results1701700.0602833.3
 (SQL Overall)1786911706.67026790.3
 
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.