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

232 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
snippier125579(None) 
nippier11319831_nippier
slippier1256531slippier
snappier1266211snappier
snipper113911331snipp_er
chippier17297672chippier
dippier123111392_dippier
drippier1385042drippier
grippier1355202grippier
hippier143212102_hippier
lippier112710572_lippier
nappier114411172_nappier
nipper103715712_nipp_er
quippier2133772quippier
sappier113613112s_appier
shipper143514042shipp_er
sipper103920992s_ipp_er
skimpier1634292skimpier
skipper15339572skipp_er
slipper113712982slipp_er
sloppier1255702sloppier
snapper113512072snapp_er
sniffier14356642sniffier
sniper84413642sni_p_er
snipped123510042snipp_ed
snippers12299722snipp_ers
snippet113310432snipp_et
snippetier1451622snippetier
snippiest1345722snippiest
snippily1543572snippily
snipping13308852snipping
snoopier10177272snoopier
soppier112711582s_oppier
stippler1235542stippler
tippier113210542_tippier
trippier1246622trippier
whippier18265822whippier
zippier20308192_zippier
chipper163912583chipp_er
chippie16297693chippie_
chippies17309753chippies
chirpier15276303chirpier
choppier17286643choppier
clipper133710323clipp_er
crappier14288133crappier
crimpier14287323crimpier
crippler14826713crippler
crispier12297253crispier
cuppier1368323_cuppier
dipper114017793_dipp_er
dripper12349233dripp_er
flappier1544293flappier
flipper14389143flipp_er
floppier1554633floppier
gappier12369843_gappier
gimpier12247943_gimpier
gipper114215303_gipp_er
gloppier1354673gloppier
gripier103210323gri_pier
gripper124410713gripp_er
happier143312033_happier
hipper133818023_hipp_er
hippie132811243_hippie_
hippies142813743_hippies
hoppier143110703_hoppier
kipper143414213_kipp_er
knapper15387153knapp_er
lipper104219633_lipp_er
loppier11369723_loppier
napper103718283_napp_er
nappie104112263_nappie_
nappies114613393_nappies
niftier10328713_niftier
nipped113615853_nipp_ed
nippers113012623_nipp_ers
nippiest12279973_nippiest
nippily1444713_nippily
nipping123412873_nipping
nipple103410373_nipple_
nippled12307643_nippled
nipples11319663_nipples
nittier73512243_nittier
pappier103511593_pappier
peppier10268323_peppier
pipier104913983_pi_pier
preppier1156643preppier
quipper2095823quipp_er
ripper103518653_ripp_er
rippler113210103_rippler
ripplier1234463_ripplier
sandpiper14103523sandpiper
sapper103822353s_app_er
scrappier1544423scrappier
scrimpier1554243scrimpier
scupper1367423scupp_er
seepier92912013s_eepier
shiftier1436343shiftier
shinier104113143shi_nier
shipped153312103shipp_ed
shippen14298863shipp_en
shippers153012313shipp_ers
shipping163611253shipping
shirtier1137943shirtier
shittier1137313shittier
shopper143312633shopp_er
shrimpier1643063shrimpier
silkier114411643s_ilkier
sillier74017593s_illier
siltier73413863s_iltier
simper103616293s_imp_er
simpler112910863s_impler
sinopie948783sinopie_
sipped113720633s_ipp_ed
sippers113117753s_ipp_ers
sippet103519393s_ipp_et
sipping123117433s_ipping
sirupier1034303sirupier
sissier73711363s_issier
sizier1514813393s_i_zier
skiddier1464193skiddier
skinnier1264893skinnier
skipped16358413skipp_ed
skippers16318203skipp_ers
skippet15288463skipp_et
skipping17297603skipping
slapper113512463slapp_er
sleepier1036783sleepier
slimier93212013sli_mier
slimpsier1343023slimpsier
slimsier1085213slimsier
slinkier12206933slinkier
slipover1343833slipover
slipped124711743slipp_ed
slipperier1442703slipperier
slippers123711233slipp_ers
slippery15275863slipp_ery
slippiest1346463slippiest
slippily1544193slippily
slipping133510663slipping
slittier837003slittier
smirkier1444433smirkier
snaggier10136303snaggier
snakier112810003sn_akier
snapped124611203snapp_ed
snappers123510173snapp_ers
snappiest1346493snappiest
snappily1544323snappily
snapping13349653snapping
snappish1545233snappish
snarkier12336513snarkier
snarlier8278183snarlier
snazzier1642483snazzier
sneakier1245143sneakier
sneerier878103sneerier
sneezier1774333sneezier
snicker133012673sni_cker
snider74413913sni__der
sniffer13318903sni_ffer
sniffler14296833sniffler
snifter10349623sni_fter
snigger9328373sni_gger
sniggler10396113sniggler
snipe75320573sni_p_e_
sniped94913483sni_p_ed
snipers93311773sni_p_ers
snipes83917393sni_p_es
sniping103712053sni_ping
snippets12225623snippets
snippety15263493snippety
snippy1374843snipp__y
snitcher13157373snitcher
sniveler1155253sniveler
snobbier1234633snobbier
snooper93511533snoop_er
snootier8278383snootier
snoozier17185193snoozier
snottier8217383snottier
snoutier8206973snoutier
snowier1038793sn_owier
snubbier1244993snubbier
snuffier14276943snuffier
soapier93411713s_oapier
soupier93111753s_oupier
spicier115112463spi_cier
spier75728033s___pier
spiffier16255883spiffier
spikier13369983spi_kier
spinier93715163spi_nier
spirier93214073spi_rier
sprier84119063s__prier
stepper113010853stepp_er
stickier14229763stickier
stillier868823stillier
stingier9279123stingier
stinkier12278543stinkier
stipple1146623stipple_
stippled1345303stippled
stipplers1334453stipplers
stipples1247023stipples
stopper113012603stopp_er
strappier1345133strappier
stripier1058863stripier
stripper1247123stripp_er
stroppier1364453stroppier
stumpier1255883stumpier
supper104115433s_upp_er
suppler1148433s_uppler
supplier1246603supplier
swampier1544593swampier
swapper14359703swapp_er
sweepier1355493sweepier
swimmier15174313swimmier
swingier12267003swingier
swipple1444633swipple_
swipples1534843swipples
swirlier1135213swirlier
swishier1434563swishier
swoopier13175143swoopier
syrupier1343053syrupier
tipper103918413_tipp_er
tippler11348343_tippler
tipsier9268893_tipsier
tripper113711923tripp_er
unhappier1642393unhappier
unifier102211863uni_fier
whipper173611383whipp_er
wimpier14248053_wimpier
wispier12249403_wispier
yippie13277843_yippie_
yippies14279293_yippies
zappier20458373_zappier
zipper193813123_zipp_er

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.203880251.2
2DLD Change Limit1461622327.98618302.3
3Display Results2322320.0932494.6
 (SQL Overall)1786912328.28221575.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.