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

322 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
hippie13281124(None) 
chippie16297691chippie
hippier143212101hippier
hippies142813741hippies
yippie13277841yippie
buppie12288732buppie
chappie16298652chappie
chippier17297672chippier
chippies17309752chippies
dippier123111392dippier
fipple13329062fipple
happier143312032happier
hempie132410562hempie
hickie153812472hickie
hiplike1637602hiplike
hipline12311422hipline
hipped144317692hipped
hipper133818022hipper
hippiest152611612hippiest
hipping153915102hipping
hippish1736182hippish
hippo12369062hipp_o
hippos13408432hippos
hippy155112792hipp_y
hirple11158972hirple
hispid1238172hispid
hoppier143110702hoppier
hopple132910482hopple
koppie14277872koppie
lippier112710572lippier
nappie104112262nappie
nippier11319832nippier
nipple103410372nipple
pippin92810302pippin
ripple103413912ripple
tippier113210542tippier
tipple103411912tipple
whippier18265822whippier
yippee132810742yippee
yippies14279292yippies
yuppie13297132yuppie
zippier20308192zippier
apple94517673_apple
bhistie1236763bhistie
biggie103810933biggie
bikie113915883bi_kie
billie85019173billie
biopic123710673biopic
birdie94013783birdie
birkie124110133birkie
buppies133011063buppies
chappies172610093chappies
cheapie1437563cheapie
chipped174110813chipped
chipper163912583chipper
chippiest18256803chippiest
chipping18389793chipping
chippy18437613chipp_y
chirpier15276303chirpier
choppier17286643choppier
civie103716353ci_vie
coppice1537483coppice
cowpie133511513cowpie
crappie13298983crappie
cripple13378583cripple
croppie13278793croppie
cuppier1368323cuppier
dapple1138853dapple
diapir9357113diapir
dickie133913113dickie
didie74120563di_die
dimple113512793dimple
diploe9810153diploe
dipole91112853dipole
dipped123517493dipped
dipper114017783dipper
dippiest132511133dippiest
dipping134014833dipping
dippy135111543dipp_y
drippier1385043drippier
fipples14298653fipples
gappier12369843gappier
ghillie11326353ghillie
gillie74816943gillie
gimmie11298173gimmie
gimpier12247933gimpier
gipped124815903gipped
gipper114215303gipper
gipping133813123gipping
gipsied1135873gipsied
gipsies1039903gipsies
girlie73711463girlie
grippe115310323gripp_e
grippier1355203grippier
gripple12416613gripple
guppies123310523guppies
hackie154615623hackie
hairpin1245413hairpin
hankie133915713hankie
haplite12310703haplite
happed144820103happed
happen134812193happen
happiest152411673happiest
happily1745763happily
happing153817233happing
happy155813533happ_y
haptic13511883haptic
harpies123818313harpies
harpin113614383harpin
hatpin112610603hatpin
hawkie163810093hawkie
heinie92512663heinie
hempier14319003hempier
hepper133412663hepper
hickies163614743hickies
hide85134623hi__de
hie67652703h___ie
higgle113811743higgle
hike116830393hi__ke
hili75626633hi_li_
hillier103413963hillier
hinge95323443hi_nge
hinkier143610793hinkier
hinnied11348103hinnied
hinnies103615103hinnies
hip86750433hi_p__
hipbone1445923hipbone
hiplines13310583hiplines
hiply134113613hi_ply
hippest14219753hippest
hippiedom1951343hippiedom
hippieish1941843hippieish
hippiness1635463hippiness
hips96433703hi_p_s
hipster12288783hipster
hircine1239143hircine
hire75538963hi__re
hiree85427803hi_ree
hirpled13157133hirpled
hirples12149643hirples
hirsle9159573hirsle
hissier103410503hissier
hissies103915823hissies
hive106029673hi__ve
hoagie102310003hoagie
hogtie102711763hogtie
homie104622523h_omie
honkie133011663honkie
hoodie105116133hoodie
hoolie93217773hoolie
hoopoe11911233hoopoe
hope96639673h_op_e
hoplite12311073hoplite
hopped144318113hopped
hopper134218483hopper
hoppiest152610723hoppiest
hopping154115273hopping
hoppled15338083hoppled
hopples142810713hopples
hoppy154912353hopp_y
hospice14117053hospice
hottie92514363hottie
howdie13349723howdie
huipil1143773huipil
humpier143110723humpier
hunkie133812383hunkie
huppah1644183huppah
hype125519813h_yp_e
hyphae1746433hyphae
hypnic1637263hypnic
impi85415773_impi_
impis96213833_impis
indie63721463_indie
jimmie17376463jimmie
kelpie12308613kelpie
kewpie15465413kewpie
kiddie12359393kiddie
killie104114893killie
kiltie103210963kiltie
kipped153114573kipped
kippen14299013kippen
kipper143414203kipper
kipping163311873kipping
koppies153210013koppies
limpid11389743limpid
lipase8239103lipase
lipe66839733li_p_e
lipid85916173li_pid
lipide93511063lipide
lipin75518893li_pin
liplike1337283liplike
lipoid9411043lipoid
lipped114419543lipped
lippen103911403lippen
lipper104219633lipper
lippiest122310613lippiest
lipping123016073lipping
lippy124511903lipp_y
loppier11369723loppier
magpie1139093magpie
mislie83219153mislie
nappe96114993napp_e
nappier114411173nappier
nappies114613393nappies
nipped113615853nipped
nipper103715713nipper
nippiest12279973nippiest
nippily1444713nippily
nipping123412873nipping
nippled12307643nippled
nipples11319663nipples
nippy124911113nipp_y
nixie125114943ni_xie
pappi84810893pappi_
pappier103511593pappier
pappies103214823pappies
peppier10268323peppier
pie55457403___pie
piggie103210773piggie
pimple123512963pimple
pinkie124414273pinkie
pipage1199143pipage
pipe86434433pi_p_e
pipier104913983pi_pier
pipit95224873pi_pit
pipkin14248603pipkin
pipped104516543pipped
pipping113414743pipping
pippins10319753pippins
pixie145415523pi_xie
plie65127393__plie
poppied11388983poppied
poppies102816193poppies
popple92710983popple
popsie103013053popsie
potpie103412423potpie
preppie1058093preppie
puppies103212613puppies
quippier2133773quippier
rappee103618673rappee
rimple103814583rimple
ripe66038923ri_p_e
ripped114419013ripped
ripper103518653ripper
ripping123315743ripping
rippled123110273rippled
rippler113210103rippler
ripples113513293ripples
ripplet113412583ripplet
ripplier1234463ripplier
ripply13348003ripply
riptide1036883riptide
sappier113613113sappier
sharpie1238383sharpie
shilpit1247093shilpit
shipped153312103shipped
shippen14298863shippen
shipper143514033shipper
shipping163611253shipping
shippon14285803shippon
shipside1445033shipside
shoppe133110313shopp_e
sickie123715743sickie
silkie103313403silkie
simple104315173simple
sinopie948773sinopie
sipe67341043si_p_e
sipped113720633sipped
sipper103920983sipper
sippet103519393sippet
sipping123117433sipping
slippier1256533slippier
snippier1255793snippier
soppier112711583soppier
stipple1146623stipple
supple10410203supple
swipple1444633swipple
tawpie11339143tawpie
tiepin839343tiepin
tipi69924433ti_pi_
tipis76019923ti_pis
tipped114418263tipped
tipper103918413tipper
tippet103917873tippet
tippiest122310013tippiest
tipping122814973tipping
tippled12358393tippled
tippler11348343tippler
tipples112811253tipples
tippy125411793tipp_y
tipsier9268893tipsier
tiptoe838283tiptoe
tittie63213153tittie
topple104411323topple
trippier1246623trippier
uppile10178503_uppile
weepie11258793weepie
whiplike2043813whiplike
whipped18379333whipped
whipper173611383whipper
whippet17328843whippet
whippiest19265113whippiest
whipping19328173whipping
whippy19385843whipp_y
whoopie15295913whoopie
widdie113410733widdie
wienie9229973wienie
willie94116453willie
wimpier14248043wimpier
wimple133611363wimple
wipe94830283wi_p_e
wispier12249403wispier
yipe96722173yi_p_e
yipped143613283yipped
yipping152710683yipping
yuppies14339263yuppies
zappier20458373zappier
zipped203612983zipped
zipper193813123zipper
zippiest21248093zippiest
zipping212910573zipping
zippy21518743zipp_y

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127163226.48317386.4
3Display Results3223220.1102927.3
 (SQL Overall)1786913226.73326539.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.