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

208 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
whippet1732884(None) 
whipped18379331whipped
whipper173611381whipper
whippets18255251whippets
chipped174110812chipped
chipper163912582chipper
hipped144317692_hipped
hipper133818022_hipper
hippest14219762_hippest
shipped153312102shipped
shippen14298862shippen
shipper143514042shipper
sippet103519392_sippet
skippet15288462skippet
snippet113310432snippet
tippet103917872_tippet
trippet113714112trippet
whapped18367572whapped
whapper17348272whapper
whiffet1965342whiffet
whimper17297722whimper
whippers18329042whippers
whippier18265822whippier
whippiest19265122whippiest
whippy19385842whipp_y
whipt135317422whi_p_t
whisper15298012whisper
whopped18358002whopped
whopper17328502whopper
whupped18365412whupped
blipped14377193blipped
chaplet14512253chaplet
chapped172711443chapped
chippers173510883chippers
chippie16297693chippie
chippier17297673chippier
chippies17309763chippies
chippiest18256813chippiest
chippy18437613chipp_y
chirped15379783chirped
chirper14359963chirper
chopped174511003chopped
chopper163611893chopper
clipped14439833clipped
clipper133710323clipper
dipnet91317473_dipnet
dipped123517493_dipped
dipper114017793_dipper
dripped13408083dripped
dripper12349233dripper
flipped15358513flipped
flipper14389143flipper
flippest1535183flippest
gipped124815903_gipped
gipper114215303_gipper
grippe115310323grippe_
gripped13419343gripped
gripper124410713gripper
grippes124810373grippes
happed144820103_happed
happen134812193_happen
hepper133412663_hepper
heppest14228153_heppest
hippie132811243_hippie
hippier143212103_hippier
hippies142813753_hippies
hippiest152611623_hippiest
hippo12369063_hipp_o
hippos13408433_hippos
hippy155112793_hipp_y
hopped144318113_hopped
hopper134218483_hopper
kipped153114573_kipped
kippen14299013_kippen
kipper143414213_kipper
lappet103817733_lappet
limpet103518633_limpet
lipped114419543_lipped
lippen103911403_lippen
lipper104219633_lipper
moppet126915093_moppet
nipped113615853_nipped
nipper103715713_nipper
pipet95533323_pi_pet
pipped104516543_pipped
poppet92717323_poppet
puppet93514593_puppet
quipped2175163quipped
quipper2095823quipper
ripped114419013_ripped
ripper103518653_ripper
ripplet113412583_ripplet
shilpit1247103shilpit
shipmen14317283shipmen
shipment15217593shipment
shippens15316803shippens
shippers153012313shippers
shippon14285803shippon
shoppe133110323shoppe_
shopped153512213shopped
shopper143312633shopper
shoppes143411403shoppes
sipped113720633_sipped
sipper103920993_sipper
sippets113310183_sippets
skipped16358413skipped
skipper15339573skipper
skippets16284563skippets
slipped124711743slipped
slipper113712983slipper
snipped123510043snipped
snipper113911333snipper
snippets12225623snippets
snippety15263493snippety
tappet103820113_tappet
thicket163213073thicket
tipped114418263_tipped
tipper103918413_tipper
tippets11339373_tippets
triplet94319213triplet
tripped123911693tripped
tripper113711923tripper
trippets12357423trippets
unwhipped2042363unwhipped
wapped144416473w_apped
whappers18276743whappers
wheeped16387503wheeped
whelped16355633whelped
whet105133783wh___et
whicker19359773whicker
whidded1634423whidded
whiffed2064473whiffed
whiffer19105323whiffer
whiffets2072523whiffets
while115418693whi_le_
whiled134514133whi_led
whiles124418013whi_les
whilst1239143whi_lst
whimpers18276613whimpers
whimsey18373893whimsey
whine116022813whi_ne_
whined134715203whi_ned
whiner124516633whi_ner
whines125120103whi_nes
whiney155012643whi_ney
whinge134311543whinge_
whinged15409153whinged
whinger1410810913whinger
whinges143610633whinges
whinier134110633whinier
whiniest14298753whiniest
whip125521843whi_p__
whipping19328173whipping
whipray1843403whipray
whips134917083whi_p_s
whipsaw1842723whipsaw
whirled14368043whirled
whirler13307603whirler
whirred14386933whirred
whished17428023whished
whishes16309443whishes
whisht154510813whi_sht
whisked18336913whisked
whisker17367933whisker
whiskey20445583whiskey
whispers16266993whispers
whispery19284293whispery
whist115322953whi__st
whisted144010013whisted
whit104834173whi___t
white114920303whi_te_
whited134814083whi_ted
whiten124111923whi_ten
whiter124316393whi_ter
whites123919883whi_tes
whitest133710113whitest
whitey154911883whi_tey
whither163510253whither
whitier133311063whitier
whities133113253whities
whitiest14259883whitiest
whitter139110893whitter
whittret1445893whittret
whizzed2234063whizzed
whizzer2134583whizzer
whizzes2134713whizzes
whomped18345473whomped
whooped16326933whooped
whoopee15287513whoopee
whooper15297153whooper
whoppers18297533whoppers
whumped18335633whumped
wicket155318943w_icket
widget113815263w_idget
wiglet105519153w_iglet
willet95124833w_illet
wimped144211513w_imped
wipe94830283w_i_pe_
wiped114722083w_i_ped
wiper105421293w_i_per
wipes104827083w_i_pes
wisped123411893w_isped
wrapped15338023wrapped
wrapper14368333wrapper
yipped143613283_yipped
yippee132810743_yippee
zipped203612983_zipped
zipper193813123_zipper

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.423422437.4
2DLD Change Limit1340272086.84319586.0
3Display Results2082080.0802600.0
 (SQL Overall)1786912087.34624324.9
 
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.