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

372 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
fipples1429865(None) 
fipple13329061fipple_
nipples11319661nipples
ripples113513291ripples
tipples112811251tipples
apples104315762_apples
cripples14298402cripples
dapples1238992dapples
dimples122813212dimples
dipoles101013752dipoles
fiddles123212602fiddles
files85441272fi__les
filles94224522fi_lles
fimbles143510652fimbles
finales104016012finales
fizzles18339062fizzles
hippies142813742hippies
hirples12149642hirples
hopples142810712hopples
nipple103410372nipple_
nippled12307642nippled
pimples133012422pimples
popples103011872popples
rimples113114222rimples
ripple103413912ripple_
rippled123110272rippled
rippler113210102rippler
ripplers12337112ripplers
ripplet113412582ripplet
ripplets12316732ripplets
simples113014942simples
stipples1247022stipples
supples11511282supples
swipples1534842swipples
tipple103411912tipple_
tippled12358392tippled
tippler11348342tippler
tipplers12336352tipplers
topples113111652topples
wimples143311172wimples
yippies14279292yippies
aisles64721143ai_sles
ampules1189433ampules
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
diploes101111483diploes
dipole91112853dipole_
dipped123517493dipp_ed
dipper114017783dipp_er
dippers123615173dippers
dippier123111393dippier
dippiest132511133dippiest
dispels10310503dispels
empales112411433empales
fables114921673f_ables
failles102914123failles
farles96025783f_arles
females12310663females
ferules103112723ferules
fettles103912733fettles
fiacres1237253fiacres
fiances12310673fiances
fibres114312123fi_bres
fibulas12228563fibulas
fices106031163fi__ces
fiches145219533fi_ches
fickle153912973fickle_
fickler16348423fickler
ficklest17267903ficklest
ficoes114613463fi_coes
ficuses12159203ficuses
fiddle113613383fiddle_
fiddled13329633fiddled
fiddler12309953fiddler
fiddlers13328283fiddlers
fidges114114383fi_dges
fields104211043fi_elds
fifes114822393fi__fes
fifties132111083fifties
figures11239103figures
filches153410723filches
file75446643fi__le_
filed95331903fi__led
filer85433003fi__ler
filers94623723fi__lers
filet85540163fi__let
filets94718953fi__lets
fille84327403fi_lle_
filled104922263fi_lled
filler94623623fi_ller
fillers104320203fi_llers
fillet95027083fi_llet
fillets103414753fi_llets
fillies103420253fillies
fillos94415073fi_llos
fills84632373fi__lls
filmless1344553filmless
films105617963fi__lms
filos86125383fi__los
fils75838693fi__l_s
fimble133611743fimble_
finagles12237553finagles
finale94116763finale_
finalis103313653finalis
finals94316163final_s
finches153914193finches
fines86644263fi__nes
finises10312903finises
finites10315923finites
finless102810783fi_nless
fiques1837973fi_ques
fireless112810593fireless
fires85740753fi__res
fishes125221343fi_shes
fishless1436413fishless
fishpoles1743633fishpoles
fitches153516193fitches
fives116027363fi__ves
fixates1737383fixates
fixes154723593fi__xes
fixures17596063fixures
fizzes174512553fi_zzes
fizzle17369713fizzle_
fizzled19357273fizzled
flapless1335343flapless
flipped15358513flipp_ed
flipper14389143flipp_er
flippers15337993flippers
flippest1535173flipp_est
floppies1546813floppies
foibles1238853foibles
folles93820473f_olles
fondles113512613fondles
footles103715713footles
foozles19329543foozles
fopped144012673fopp_ed
frappes14328383frappes
fribbles15287713fribbles
frijoles1834373frijoles
frizzles19297283frizzles
fuddles123611933fuddles
fugles104715783f_ugles
fumbles143514413fumbles
funplex1932833funplex
giggles103312933giggles
gipped124815903gipp_ed
gipper114215303gipp_er
gippers123212073gippers
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
impels10389513_impels
impled113812503_impled
implies11312113_implies
ingles74420873_ingles
inkles103515653_inkles
isles54220563_i_sles
istles62814983_istles
ixtles13217063_ixtles
jiggles164111433jiggles
jingles153816383jingles
kibbles153510253kibbles
kindles123614843kindles
kipped153114573kipp_ed
kippen14299013kipp_en
kipper143414203kipp_er
kippers153211423kippers
kirtles11309663kirtles
kittles113012493kittles
koppies153210013koppies
ligules82210913ligules
lipases9209483lipases
lipides103810623lipides
lipless9259553li_pless
lipped114419543lipp_ed
lippen103911403lipp_en
lippens11328533lippens
lipper104219633lipp_er
lippers113416433lippers
lippier112710573lippier
lippiest122310613lippiest
lisles63416283li_sles
littles73212783littles
maples104819423_maples
mickles153415003mickles
middles113415303middles
miggles113512033miggles
miles74645073mi__les
milles84526563mi_lles
mingles103719003mingles
mispled12310463mispled
mizzles17329493mizzles
nappes104515623napp_es
nappies114613393nappies
nibbles114011693nibbles
nickles133713823nickles
niggles93512203niggles
nipped113615853nipp_ed
nipper103715713nipp_er
nippers113012613nippers
nippier11319833nippier
nippiest12279973nippiest
nopales93812523nopales
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
rippers114115023rippers
ripplier1234463ripplier
rippliest1334763rippliest
ripply13348003rippl_y
rumples113313133rumples
samples112815453samples
sickles133417543sickles
sidles74721153si_dles
similes92915233similes
simple104315173simple_
simpler112910863simpler
simplest122310223simplest
simplex18256393simplex
singles83520433singles
sipes76036953si_p_es
sipped113720633sipp_ed
sipper103920983sipp_er
sippers113117743sippers
sippet103519393sipp_et
sippets113310173sippets
sizzles15349633sizzles
spales84728103_spales
spiles84227913_spiles
staples93617213staples
stipple1146623stipple_
stippled1345303stippled
stippler1235543stippler
stipplers1334433stipplers
stipules1037053stipules
stopples1236953stopples
supple10410203supple_
suppled1248463suppled
suppler1148433suppler
supplest1248933supplest
supplies1268823supplies
swiples12339643swiples
swipple1444633swipple_
temples112610893temples
tickles133416853tickles
tiles55542103ti__les
tingles83818313tingles
tinkles113713923tinkles
tipless92610063ti_pless
tipped114418263tipp_ed
tipper103918413tipp_er
tippers113414343tippers
tippet103917873tipp_et
tippets11339373tippets
tippier113210543tippier
tippiest122310013tippiest
tiptoes939173tiptoes
titles63719923ti_tles
tittles73413253tittles
topple104411323topple_
toppled12348843toppled
triples94616873triples
unpiles92112783unpiles
uppiles11208263uppiles
vittles103211113vittles
widdles123514343widdles
wiggles123312463wiggles
wiles85437873wi__les
wimbles143010843wimbles
wimple133611363wimple_
wimpled15338823wimpled
windles113518493windles
winkles143412773winkles
wintles103414983wintles
wipes104827083wi_p_es
yipes106017843yi_p_es
yipped143613283yipp_ed
yippee132810743yipp_ee
yippie13277843yippie_
yuppies14339263yuppies
zeppoles2143583zeppoles
zipless18276303zi_pless
zipped203612983zipp_ed
zipper193813123zipp_er
zippers203310373zippers
zippier20308193zippier
zippiest21248093zippiest
zizzles14307093zizzles

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340273726.23321502.8
3Display Results3723720.1262952.4
 (SQL Overall)1786913726.51527427.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.