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

367 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
nipples1131966(None) 
fipples14298651fipples
nipple103410371nipple_
nippled12307641nippled
ripples113513291ripples
tipples112811251tipples
apples104315762_apples
cripples14298402cripples
dapples1238992dapples
dimples122813212dimples
dipoles101013752dipoles
fipple13329062fipple_
hippies142813742hippies
hirples12149642hirples
hopples142810712hopples
nappes104515622napp_es
nappies114613392nappies
nibbles114011692nibbles
nickles133713822nickles
niggles93512202niggles
nipped113615852nipp_ed
nipper103715712nipp_er
nippers113012622nippers
nippier11319832nippier
nippiest12279972nippiest
nopales93812522nopales
pimples133012422pimples
popples103011872popples
rimples113114222rimples
ripple103413912ripple_
rippled123110272rippled
rippler113210102rippler
ripplers12337112ripplers
ripplet113412582ripplet
ripplets12316732ripplets
simples113014942simples
stipples1247022stipples
supples11511282supples
swipples1534842swipples
tipple103411912tipple_
tippled12358392tippled
tippler11348342tippler
tipplers12336352tipplers
topples113111652topples
wimples143311172wimples
yippies14279292yippies
aisles64721143ai_sles
ampules1189433ampules
anisoles81010123anisoles
antipoles11810473antipoles
appels104312793_appels
apple94517673_apple_
applet105917433_applet
applets115710063_applets
applies11311213_applies
bibles104617643bi_bles
biles75542143bi__les
bindles104016453bindles
birles84920643bi_rles
buppies133011063buppies
chippies17309753chippies
circles1139903circles
citoles9312553citoles
couples115317053couples
crimples14308963crimples
cripple13378583cripple_
crippled15336793crippled
crippler14826713crippler
cripplers15314993cripplers
cupules113210263cupules
dapple1138853dapple_
dappled1336393dappled
dibbles124013333dibbles
diddles103915073diddles
dimple113512793dimple_
dimpled132810303dimpled
dindles93817243dindles
dingles93818323dingles
diplex16408053di_plex
diploes101111493diploes
dipole91112853dipole_
dipped123517493dipp_ed
dipper114017793dipp_er
dippers123615183dippers
dippier123111393dippier
dippiest132511133dippiest
dispels10310503dispels
empales112411433empales
enisles72312603eni_sles
fiddles123212603fiddles
files85441273fi__les
filles94224523fi_lles
fimbles143510663fimbles
finales104016013finales
fizzles18339063fizzles
giggles103312933giggles
gipped124815903gipp_ed
gipper114215303gipp_er
gippers123212083gippers
gipsies1039903gipsies
girdles92210003girdles
grapples13348123grapples
grippes124810373gripp_es
gripple12416613gripple_
guppies123310523guppies
higgles123911803higgles
hipless12399923hi_pless
hipped144317693hipp_ed
hipper133818023hipp_er
hippest14219753hipp_est
hippie132811243hippie_
hippier143212103hippier
hippiest152611613hippiest
hippos13408433hipp_os
hirple11158973hirple_
hirpled13157133hirpled
hirsles101510073hirsles
hopple132910483hopple_
hoppled15338083hoppled
huipiles1344423huipiles
idles66720123_i_dles
impales113311763impales
impels10389523_impels
impled113812513_impled
implies11312123_implies
indoles83716363indoles
ingles74420873_ingles
inhales10511863inhales
inkles103515653_inkles
insoles73516243insoles
isles54220563_i_sles
istles62814983_istles
ixtles13217063_ixtles
jiggles164111433jiggles
jingles153816383jingles
kibbles153510253kibbles
kindles123614843kindles
kipped153114573kipp_ed
kippen14299013kipp_en
kipper143414213kipp_er
kippers153211433kippers
kirtles11309663kirtles
kittles113012493kittles
koppies153210013koppies
ligules82210923ligules
lipases9209483lipases
lipides103810623lipides
lipless9259553li_pless
lipped114419543lipp_ed
lippen103911403lipp_en
lippens11328533lippens
lipper104219633lipp_er
lippers113416443lippers
lippier112710573lippier
lippiest122310613lippiest
lisles63416283li_sles
littles73212783littles
maniples12269423mani_ples
maples104819423_maples
mickles153415003mickles
middles113415303middles
miggles113512033miggles
miles74645073mi__les
milles84526563mi_lles
mingles103719003mingles
mispled12310463mispled
mizzles17329493mizzles
napalms1144033napalms
napes74828463n_ap_es
napless93110283n_apless
nappas105511613napp_as
nappe96114993napp_e_
napped114218163napp_ed
napper103718283napp_er
nappers114214863nappers
nappie104112263nappie_
nappier114411173nappier
nappiest122510883nappiest
needles83211563needles
nestles73015463nestles
nettles73214083nettles
nibble103713283nibble_
nibbled12389073nibbled
nibbler11379273nibbler
nibblers12306543nibblers
niches114419143ni_ches
nickels13338653nickels
nickle123814483nickle_
nickled144010443nickled
nicols8810243nicol_s
nidates8311893nidates
nides65229133ni__des
niduses837013niduses
nieces84112713ni_eces
niellos736143niellos
nieves94311293ni_eves
nifties102612503nifties
niggle83612823niggle_
niggled10319203niggled
niggler93610293niggler
nigglers10307253nigglers
nihils937573nihil_s
nilled73919453ni_lled
nills54926673ni__lls
nils46132453ni__l_s
nimble103412943nimble_
nimbler11358063nimbler
nimblest1236923nimblest
nines55937343ni__nes
ninnies73713613ninnies
nipas77116673ni_p_as
nippily1444713nippily
nippiness1334713nippiness
nipping123412873nipping
nippy124911113nipp__y
nips65830923ni_p__s
nites55736343ni__tes
nitres65519333ni_tres
nitriles8269923nitriles
nixes124519623ni__xes
nixies135313873ni_xies
nobbles114014523nobbles
nobles83319723n_obles
noddles92911293noddles
nodules8269703nodules
nombles113212343nombles
nonplus936183nonplus
nonuples1056533nonuples
noodles83513193noodles
nopals84914023nopal_s
nozzles15276303nozzles
nubbles113412433nubbles
numbles113814273numbles
nuncles939843nuncles
nuzzles15298123nuzzles
pales75753803__pales
pappies103214823pappies
papules112411573papules
peles75738083__peles
peoples11312213peoples
pickles153215443pickles
piddles114314273piddles
piffles15368763piffles
piles74742613__piles
pilules9510623pilules
pimple123512963pimple_
pimpled14289183pimpled
pinoles93418703pinoles
pintles94118723pintles
pipages1289423pipages
pipals104213643pipal_s
pipeless12107663pipeless
pipes96030143pi_p_es
pipped104516543pipp_ed
pippins10319753pippins
pizzles17329273pizzles
poles75351003__poles
poppies102816193poppies
popple92710983popple_
poppled11339233poppled
pules74538813__pules
puppies103212613puppies
purples112712823purples
rappees113611453rappees
rappels11448803rappels
riddles93215023riddles
riffles133911163riffles
rifles94217703ri_fles
riles55343643ri__les
rilles64725503ri_lles
rimple103814583rimple_
rimpled123311423rimpled
ripes75435773ri_p_es
ripped114419013ripp_ed
ripper103518653ripp_er
rippers114115033rippers
ripplier1234463ripplier
rippliest1334763rippliest
ripply13348003rippl_y
rumples113313133rumples
samples112815453samples
sickles133417543sickles
sidles74721153si_dles
similes92915233similes
simple104315173simple_
simpler112910863simpler
simplest122310223simplest
simplex18256393simplex
singles83520433singles
sipes76036953si_p_es
sipped113720633sipp_ed
sipper103920993sipp_er
sippers113117753sippers
sippet103519393sipp_et
sippets113310183sippets
sizzles15349633sizzles
sniffles14257713sniffles
sniggles10307313sniggles
snipes83917393sni_p_es
snipped123510043snipp_ed
snipper113911333snipp_er
snippers12299723snippers
snippet113310433snipp_et
snippets12225623snippets
snippier1255793snippier
snippiest1345713snippiest
spales84728103_spales
spiles84227913_spiles
staples93617213staples
stipple1146623stipple_
stippled1345303stippled
stippler1235543stippler
stipplers1334453stipplers
stipules1037053stipules
stopples1236953stopples
supple10410203supple_
suppled1248463suppled
suppler1148433suppler
supplest1248933supplest
supplies1268823supplies
swiples12339643swiples
swipple1444633swipple_
temples112610893temples
tickles133416853tickles
tiles55542103ti__les
tingles83818323tingles
tinkles113713923tinkles
tipless92610063ti_pless
tipped114418263tipp_ed
tipper103918413tipp_er
tippers113414353tippers
tippet103917873tipp_et
tippets11339373tippets
tippier113210543tippier
tippiest122310013tippiest
tiptoes939173tiptoes
titles63719923ti_tles
tittles73413253tittles
topple104411323topple_
toppled12348843toppled
triples94616873triples
unpiles92112783unpiles
uppiles11208263uppiles
vittles103211113vittles
widdles123514343widdles
wiggles123312463wiggles
wiles85437873wi__les
wimbles143010853wimbles
wimple133611363wimple_
wimpled15338823wimpled
windles113518493windles
winkles143412773winkles
wintles103414983wintles
wipes104827083wi_p_es
yipes106017843yi_p_es
yipped143613283yipp_ed
yippee132810743yipp_ee
yippie13277843yippie_
yuppies14339263yuppies
zeppoles2143583zeppoles
zipless18276303zi_pless
zipped203612983zipp_ed
zipper193813123zipp_er
zippers203310383zippers
zippier20308193zippier
zippiest21248093zippiest
zizzles14307093zizzles

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.1701051123.5
2DLD Change Limit1340273677.17318684.9
3Display Results3673670.1232983.7
 (SQL Overall)1786913677.46623934.0
 
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.