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

217 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
zippiest2124810(None) 
dippiest132511141dippiest
hippiest152611621hippiest
lippiest122310621lippiest
nippiest12279981nippiest
tippiest122310021tippiest
zappiest21228031zappiest
chippiest18256812chippiest
cuppiest1448202cuppiest
drippiest1445382drippiest
gappiest13259482gappiest
gimpiest1338482gimpiest
grippiest1435162grippiest
happiest152411682happiest
hippest14219762hipp_est
hippies142813752hippies_
hoppiest152610732hoppiest
loppiest122410112loppiest
nappiest122510892nappiest
pappiest112611122pappiest
peppiest11278572peppiest
pipiest113114502pi_piest
quippiest2243992quippiest
rippliest1334782rippliest
sappiest122612582sappiest
slippiest1346472slippiest
snippiest1345732snippiest
soppiest122511942soppiest
tipsiest10228952tipsiest
trippiest1336602trippiest
whippiest19265122whippiest
wimpiest1538762wimpiest
wispiest1339512wispiest
yippies14279292yippies_
zingiest182810892zingiest
zippier20308192zippie_r
airiest74221013ai_riest
bilgiest11309883bilgiest
bitsiest102610063bitsiest
bittiest103012043bittiest
bumpiest1437873bumpiest
buppies133011063buppies_
campiest142212143campiest
chippies17309763chippies_
chirpiest16286483chirpiest
choppiest18226383choppiest
crappiest15267273crappiest
crepiest12310383crepiest
crimpiest15237183crimpiest
crispiest13197423crispiest
diciest103316523di_ciest
dickiest153412503dickiest
dictiest113212783dictiest
dimpliest1436583dimpliest
dingiest102915373dingiest
dinkiest133812873dinkiest
dippier123111393dippie_r
dippiness1435973dippiness
dirtiest93014203dirtiest
dishiest12313683dishiest
ditsiest92111333ditsiest
ditziest18218473ditziest
dizziest17266723dizziest
dopiest103315993_dopiest
dumpiest1338743dumpiest
emptiest1278103emptiest
fieriest112112243fieriest
filmiest1338553filmiest
finniest113011403finniest
fipples14298653fipples_
firriest112310433firriest
fishiest14310453fishiest
fizziest19226073fizziest
flappiest1644863flappiest
flippest1535183flipp_est
floppiest1654793floppiest
giddiest11298553giddiest
ginniest92610513ginniest
gipsies1039903gipsies_
girliest93010403girliest
gloppiest1444833gloppiest
goopiest112710553goopiest
grapiest112211933grapiest
gripiest11289633gripiest
gulpiest1137353gulpiest
guppies123310523guppies_
hempiest1539043hempiest
heppest14228153hepp_est
hilliest113914113hilliest
hinkiest153311753hinkiest
hippie132811243hippie__
hippieish1941843hippieish
hippier143212103hippie_r
hippiness1635463hippiness
hippish1736183hippi_sh
hissiest112911093hissiest
humpiest1538973humpiest
iciest82914743_i_ciest
ickiest133611043_ickiest
iffiest1337973_iffiest
imprest11310203_imprest
inkiest113415043_inkiest
jiggiest17277693jiggiest
jimpest18297553jimp_est
jiviest1738113ji_viest
jumpiest1936863jumpiest
kickiest13319673kickiest
kinkiest113110503kinkiest
koppies153210013koppies_
limbiest12258893limbiest
limiest93716103li_miest
limpest113712313limp_est
limpsiest1344803limpsiest
lingiest93715263lingiest
liniest73321153li_niest
lintiest82715913lintiest
lippier112710573lippie_r
lippiness1335413lippiness
loopiest103011323loopiest
lumpiest1239263lumpiest
miffiest1637143miffiest
milkiest142911083milkiest
miltiest103015173miltiest
minciest122913113minciest
mingiest113315823mingiest
mintiest103217143mintiest
miriest93619823mi_riest
mirkiest142910253mirkiest
mistiest103018313mistiest
mitiest93520053mi_tiest
mopiest113014293_mopiest
nappies114613403nappies_
niftiest112910073niftiest
nippier11319833nippie_r
nippiness1334713nippiness
nipples11319663nipples_
nittiest82712603nittiest
oiliest72817683oi_liest
pappies103214833pappies_
pickiest162712593pickiest
piggiest12259663piggiest
pimpliest1545483pimpliest
piniest93121133pi_niest
pippins10319753pippins_
pithiest132711443pithiest
poppies102816203poppies_
preppiest1236983preppiest
priest84125423__priest
pulpiest1258443pulpiest
puppies103212623puppies_
raspiest10311283raspiest
ribbiest1237583ribbiest
ridgiest1038903ridgiest
rimiest93215853ri_miest
ripest84317943ri_p_est
ripples113513293ripples_
ripplet113412583ripple_t
ripplets12316733ripplets
riskiest12310133riskiest
ritziest17237843ritziest
ropiest93317773_ropiest
roupiest102610293roupiest
seepiest102412633seepiest
silkiest123212853silkiest
silliest84017103silliest
siltiest83515613siltiest
simplest122310223simplest
sippet103519393sipp_e_t
sippets113310183sipp_ets
sirupiest1154763sirupiest
sissiest83412353sissiest
siziest16311473si_ziest
skimpiest1734513skimpiest
sloppiest1345983sloppiest
snappiest1346503snappiest
soapiest102412853soapiest
soupiest102212923soupiest
spiciest122711613spiciest
spikiest14259543spikiest
spiniest102813233spiniest
spiriest102513463spiriest
spriest92718653_spriest
supplest1248953supplest
tidiest83514873ti_diest
tiniest73020123ti_niest
tinniest82911463tinniest
tippet103917873tipp_e_t
tippets11339373tipp_ets
tippier113210543tippie_r
tipples112811253tipples_
typiest1238203_typiest
vampiest15237653vampiest
viewiest1435853viewiest
viniest103216613vi_niest
waspiest1338823waspiest
weepiest13219473weepiest
wiftiest14279173wiftiest
wiggiest13269013wiggiest
wiliest103416593wi_liest
windiest122213233windiest
wingiest123214283wingiest
winiest103419693wi_niest
wiriest103816853wi_riest
withiest142411243withiest
wittiest112711523wittiest
yippie13277843yippie__
yuppies14339263yuppies_
zaniest163214773z_aniest
zappier20458373zappie_r
zestiest173011103zestiest
zipless18276303zi_pless
zipped203612983zipp_e_d
zipper193813123zipp_e_r
zippers203310383zipp_ers
zipping212910573zippi_ng
zooiest16199923z_ooiest
zootiest173311213zootiest

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.423422437.4
2DLD Change Limit1461622176.06024119.1
3Display Results2172170.0932333.3
 (SQL Overall)1786912176.57627173.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.