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

500 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
fettle9371312(None) 
fettled11378931fettled
fettles103912731fettles
kettle104311611kettle
mettle83815721mettle
nettle64514581nettle
pettle84116051pettle
settle63915661settle
battle85217862battle
beetle8311672beetle
bottle84916072bottle
cattle85118902cattle
cuttle84113892cuttle
dottle74212502dottle
featly123711752featly
feeble1138252feeble
female11310552female
fertile10311732fertile
ferule93413202ferule
fetal85623372fetal_
fete75734922fe_t_e
fetted104817892fetted
fetter94120382fetter
footle93914382footle
futile93914952futile
fytte1138582fytt_e
gentle74014512gentle
guttle74111972guttle
kettles113411612kettles
kittle104012172kittle
little63312162little
mettled103510542mettled
mettles94115022mettles
mottle84116052mottle
nestle63013952nestle
nettled8339942nettled
nettler7349502nettler
nettles73214082nettles
nettly9459452nettly
pestle83215842pestle
pettled103611502pettled
pettles93916482pettles
pottle84416102pottle
rattle64717612rattle
retile65929672retile
retitle73913092retitle
settee63721022settee
settled83210872settled
settler73410652settler
settles73916002settles
tattle64115652tattle
tittle63613322tittle
vittle94711752vittle
wattle94314212wattle
aedile73716653aedile
battled104213123battled
battler94113383battler
battles94517683battles
battue84311003battue
beadle93314683beadle
beagle93612593beagle
beetled1038213beetled
beetler938033beetler
beetles9312083beetles
belittle1044053belittle
belle75827833be_lle
betake124512703betake
betel74419903betel_
betels84515063betels
bethel1169643bethel
betide95115973betide
betime105914833betime
betise85616273betise
betta74916843bett_a
bettas84913923bettas
betted94721163betted
better84723703better
bettor83612223bettor
bottled104611233bottled
bottler94211883bottler
bottles94216273bottles
brattle9249253brattle
brittle9168603brittle
bustle84015483bustle
butle75023103_butle
butte74924293butt_e
cantle84522153cantle
castle84918963castle
cattie85221013cattie
centile94217183centile
centre84316643centre
cetane8315283cetane
cete64934783ce_t_e
citole8311503citole
cottae84615703cottae
cuittle946403cuittle
cuttled10319933cuttled
cuttles93613923cuttles
dartle73714833dartle
decile94619213decile
deckle1312012453deckle
defile105216663defile
deftly1336533deftly
dele56843083de__le
dottel73610893dottel
dottles83912283dottles
eagle64219483_eagle
edile64819493_edile
entitle7610293entitle
etape74413703_etape
etoile6312263_etoile
etude63612303_etude
etwee84115333_etwee
exile126117653_exile
fable105824753f_able
facile112514883facile
faille93414743faille
farle86929243f_arle
fartlek1434493fartlek
fatal84819373fatal_
fate75444283f_at_e
fatly115716803f_atly
fatted105419843fatted
fatten94314903fatten
fatter94523213fatter
fattier103513463fattier
fatties103018203fatties
fattily13379463fattily
fatty115117413fatt_y
feal713940423fe_al_
fealty122910223fealty
fease84824873fe_ase
feat76458223feat__
feater95224053feater
feather133613503feather
featlier1136453featlier
feats86432753feat_s
feature1039853feature
feaze175216313fe_aze
febrile1237153febrile
fecal105119213fecal_
feckly18335963feckly
fecula113310053fecula
feculae12339203feculae
fee66862013fe___e
feebler1235823feebler
feebly1436653feebly
feel75233843fe_el_
feeler93215173fe_eler
feels85223043fe_els
feet75352213feet__
feetless1137383feetless
feeze174913823fe_eze
feirie939553feirie
feline94820143feline
fell76833073fe__ll
fella84918653fe_lla
felled103720303fe_lled
feller94419553fe_ller
felloe93513923felloe
fells85327383fe_lls
felly114922803fe_lly
felt75146933fe__lt
felted103714653felted
feltlike1534983feltlike
felts85324543felt_s
females12310663females
feme96130543fe__me
femme125011433fe_mme
fenagle11197153fenagle
fence105319913fe_nce
fennel9429473fennel
feral85424653feral_
ferals94216643ferals
fere76342233fe__re
feriae95618603feriae
ferine96422583ferine
ferlie92814053ferlie
ferly115517353fe_rly
ferrel92810203ferrel
ferrule1035863ferrule
ferula93011173ferula
ferulae10309603ferulae
feruled11318413feruled
ferules103112723ferules
fescue1137493fescue
fesse86116333fe_sse
fest74949443fest__
festal94213563festal
fester94723513fester
festive1339773festive
fests85828043fest_s
fet66471633fe_t__
feta76528903fe_t_a
fetas85624403fe_tas
fetch134913473fe_tch
fetched163710473fetched
fetcher153510393fetcher
fetches153413893fetches
feted94420933fe_ted
fetes85630143fe_tes
fetial95716193fetial
fetiales11319613fetiales
fetials103711743fetials
fetich1479693fetich
fetid93715983fe_tid
fetidly1435013fetidly
feting104417793feting
fetish12310373fetish
fetor81214533fe_tor
fetors91014473fetors
fets75345943fe_t_s
fettered12259493fettered
fetterer11207813fetterer
fetters103517903fetters
fetting113517873fetting
fettling1266773fettling
fetus85816543fe_tus
fetuses10310243fetuses
feyly14429513fe_yly
fickle153912973fickle
fictile1238023fictile
fiddle113613383fiddle
file75446643f__ile
fille84327403f_ille
fimble133611743fimble
finale94116763finale
fipple13329063fipple
fitly115114973f_itly
fittable1337083fittable
fitted104716663fitted
fitter94120033fitter
fizzle17369713fizzle
flatlet10312253flatlet
flatly123110213flatly
fleetly1336313fleetly
flexile1735073flexile
flite85424963flit_e
flute86823753flut_e
flyte115713943flyt_e
foetal9311883foetal_
foible11410383foible
fondle104412943fondle
footie94718133footie
footled113610763footled
footler104011863footler
footles103715713footles
foozle18369203foozle
forte86131463fort_e
fouette1038213fouett_e
freckle16106643freckle
fretted113411853fretted
fretter103412753fretter
frettier1156593frettier
fretty1249223frett_y
fuddle113312103fuddle
fugle94915543f_ugle
fumble133214263fumble
fumette1245523fumett_e
fusile94313493fusile
future939563future
fyttes1236933fyttes
gentile83515293gentile
gentled9389093gentled
gentler8378953gentler
gentles83714343gentles
gently103710913gently
geste65920693gest_e
getable101712553getable
gettable11178133gettable
getter74117613getter
guttae73210583guttae
guttled9378993guttled
guttler8369163guttler
guttles83011933guttles
hantle94318203hantle
heckle153112093heckle
heddle114211163heddle
hottie92514363hottie
hurtle93512943hurtle
hustle93113993hustle
intitle7610583intitle
istle52214713_istle
ixtle12168013_ixtle
jete115927253je_t_e
jetted143915083jetted
jettied15366973jettied
jettier14358693jettier
jetties143613123jetties
jetton1338033jetton
jetty156212583jett_y
jostle13319863jostle
justle133211583justle
keckle11359423keckle
kente95821063kent_e
ketene106613003ketene
ketol95414003ketol_
ketols104210763ketols
ketone105014533ketone
ketose105711813ketose
kirtle10309473kirtle
kittel10368863kittel
kittled12388193kittled
kittler11338163kittler
kittles113012493kittles
latte55426303latt_e
lethe85717303le_the
letted74118543letted
letter63722583letter
lettuce943323lettuce
littler7348553littler
littles73212783littles
lotte54923853lott_e
lyttae994713lyttae
mantle84420923mantle
matte75626843matt_e
measle83513223measle
meddle103312763meddle
meetly1138673meetly
meikle1236653meikle
mentee84121293mentee
merle75824373me_rle
mestee84523883mestee
metage93114453metage
metal75427383metal_
metaled102913873metaled
metals84520883metals
metate82720533metate
mete64438133me_t_e
metol75917813metol_
metols84115773metols
metope10611123metope
metre74821303me_tre
mofette1296773mofett_e
motile83818343motile
motte75526973mott_e
mottled10409973mottled
mottler94410343mottler
mottles93415803mottles
mutule8311423mutule
myrtle1135733myrtle
neatly93812483neatly
nebule848753nebule
needle73310613needle
nestled8349903nestled
nestler73510443nestler
nestles73015463nestles
nett46643233nett__
nettable101610243nettable
netted74118713netted
netter63722023netter
nettier74211813nettier
nettlers8307513nettlers
nettlier864813nettlier
netts55320723nett_s
netty85816763nett_y
pattee84323383pattee
pattie84020963pattie
pebble1238003pebble
peddle103512823peddle
pele65539553pe__le
penile82219603penile
people10310183people
pertly115312543pertly
pestled102711433pestled
pestles93217693pestles
petal76526893petal_
petaled103614143petaled
petals84719813petals
petiole9311303petiole
petite84320653petite
petrale9312623petrale
petrel83111533petrel
pettable121710713pettable
petted94121523petted
petter83924773petter
petti75119453pett_i
pettier94213613pettier
pettily1238173pettily
petto76021043pett_o
petty105320293pett_y
pintle83818263pintle
pottles93816983pottles
prattle9208833prattle
puttee85919723puttee
puttie84116303puttie
rattled84012953rattled
rattler74012743rattler
rattles73217303rattles
rattly94111543rattly
rebottle1044343rebottle
reddle83815913reddle
refile95122373refile
regale74821453regale
rente54733783rent_e
reptile93914083reptile
resale64025543resale
resettle837303resettle
resile64627673resile
resole64624183resole
restyle1038763restyle
retable91820403retable
retake104718533retake
retape83917683retape
rete44944133re_t_e
retell63813643retell
retene69224273retene
reticle94112623reticle
retie55735303re_tie
retiled84420513retiled
retiles74426993retiles
retime85321803retime
retine66237333retine
retire64927013retire
retitled9339553retitled
retitles83612593retitles
retold73013753retold
retore67630763retore
retted74826313retted
retune69121953retune
retuse66617223retuse
retype11399143retype
revile94921613revile
rootle63214453rootle
rotte54625933rott_e
rustle63615413rustle
rutile65217683rutile
scuttle936463scuttle
sectile9311973sectile
sedile73517233sedile
seethe93712483seethe
selle54428313se_lle
semple103212753semple
senile63420213senile
sente56432873sent_e
setae56026223se_tae
setal56430903setal_
setose65114773setose
sett45949053sett__
settees73513633settees
setter64023723setter
settlers8289023settlers
settlor7314733settlor
setts55124323sett_s
sextile1438573sextile
shuttle1046093shuttle
skittle1135523skittle
spittle937923spittle
stale55637103_stale
stele55026843_stele
stile54931573_stile
stole54928813_stole
style85519363_style
subtle82113433subtle
suttee63721543suttee
tale46154163__tale
tattie64817513tattie
tattled84311483tattled
tattler73112213tattler
tattles73616283tattles
teazle15329553teazle
teethe94511313teethe
tele45040873__tele
temple102811333temple
tentie62521183tentie
testae64216253testae
testee64323303testee
tetter64322453tetter
textile1437223textile
tile45451443__tile
title54721073_title
tittie63213153tittie
tittles73413253tittles
tole46052903__tole
tootle62613813tootle
trestle72611363trestle
tule45735873__tule
turtle63213573turtle
twattle1064273twattle
unsettle866063unsettle
utile54718933_utile
venule94411763venule
vestee94319153vestee
vetted104316323vetted
vetter93417643vetter
vittae93910993vittae
vittled11347343vittled
vittles103211113vittles
wattled113610503wattled
wattles103814073wattles
wetly114511713we_tly
wettable13148043wettable
wetted103717023wetted
wetter93919443wetter
whittle13106103whittle
wintle94014603wintle
wrestle10298843wrestle
yente86220043yent_e
yett76434493yett__
yetts86715133yett_s

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.1431249587.4
2DLD Change Limit1127165006.45317467.2
3Display Results5005000.1702941.2
 (SQL Overall)1786915006.76626410.1
 
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.