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

291 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
tattoo631097(None) 
tattoos738641tattoos
datto65416422datt_o
dattos74311902dattos
ratton64116122ratton
rattoon7359242rattoon
taboo73418092ta_boo
tanto55724942tant_o
tatsoi637262tatsoi
tatted74920532tatted
tatter64024572tatter
tattie64817512tattie
tattle64115652tattle
tattooed944572tattooed
tattooer844372tattooer
tatty84720182tatt_y
tautog765712tautog
achoo10315083_achoo
actor71116073_actor
altho86312603_altho
alto47831263_alt_o
altos55822953_altos
anatto6139913anatt_o
anattos7138453anattos
atom67824523_a_tom
atop66124753_a_top
att35454653_att__
attar56516693_attar
attic75618353_attic
attorn6310793_attorn
auto47432083_aut_o
autos56523323_autos
baboo94319503ba_boo
bamboo12310013bamboo
batboy1387533batboy
bathos116215633bathos
baton75822423ba_ton
batt65053873batt__
batted95623653batted
batten85217123batten
batter84928873batter
battik1238093battik
battle85217863battle
batts76727563batt_s
battu75216613batt_u
battue84311003battue
batty105422243batt_y
bazoo163815673ba_zoo
bettor83612223bettor
bottom1048713bottom
button8310273button
canto74931013cant_o
canton85722993canton
cantor85621523cantor
cantos84826973cantos
captor104914603captor
carton84522663carton
cartoon94114463cartoon
cartop104213563cartop
cashoo11312253cashoo
castor84418533castor
catalo8314853catalo
cation83925503cation
cattalo938423cattalo
catted95422473catted
cattie85221013cattie
cattle85118903cattle
catty104520413catt_y
cotton8312993cotton
dalton7311273dalton
dato56129943da_t_o
datos65222783da_tos
ditto65315603ditt_o
dittos74111973dittos
factor11911453factor
fantod102010033fantod
fantom112110803fantom
fathom1437473fathom
fatso85113493fa_tso
fatsos9389423fatsos
fatted105419843fatted
fatten94314903fatten
fatter94523213fatter
fatty115117413fatt_y
fatwood1486393fatwood
flattop1244403flattop
gator64416033ga_tor
gazoo153112873ga_zoo
gentoo7311313gentoo
halloo95118973halloo
hatbox1835133hatbox
hatted104921513hatted
hatter94724873hatter
jato115822683ja_t_o
jatos125116823ja_tos
jetton1338033jetton
karoo92519583ka_roo
karroo10410013karroo
kation104315683kation
kazoo183311533ka_zoo
laptop1076813laptop
latigo73410013latigo
latino64120473latino
latte55426303latt_e
latten65018203latten
latter65027893latter
lattes65324203lattes
lattin64316223lattin
lotto55217573lott_o
lottos64613103lottos
madtom1138023madtom
maltol8310843maltol
matron83918313matron
matt65752653matt__
matte75626843matt_e
matted94521413matted
matter84325343matter
mattes85624533mattes
mattin84416633mattin
mattock1535823mattock
mattoid1079273mattoid
matts76829183matt_s
matzo16312893ma_tzo
matzoh2035483matzoh
matzoon1896473matzoon
matzos1749263matzos
matzot17710983matzot
motto76119513mott_o
mottos84615243mottos
mutton8510453mutton
nation64322803nation
natron64116023natron
natter64420743natter
natty85719143natt_y
otto45220643_ott_o
ottos54714323_ottos
panto76129413pant_o
pantos85222743pantos
parton84720993parton
partook1337313partook
pastor84817483pastor
pathos115516693pathos
patio74426353pa_tio
patios85221783patios
patrol83213023patrol
patron84018043patron
patroon92811973patroon
patted94724683patted
pattee84323383pattee
patten84418193patten
patter84628263patter
pattie84020963pattie
patty104723613patt_y
petto76021043pett_o
potto75320943pott_o
pottos84615873pottos
putto75617663putt_o
ragtop936683ragtop
raptor83912823raptor
ratio55227583ra_tio
ration64226013ration
ratios64922673ratios
rato45436973ra_t_o
ratoon64417373ratoon
ratos55528763ra_tos
rattan63613603rattan
ratted74923343ratted
ratten64217383ratten
ratter64326313ratter
rattle64717613rattle
rattly94111543rattly
rattons73815323rattons
rattoons8327513rattoons
ratty84819593ratt_y
santo56227283sant_o
santol64515243santol
santoor737433santoor
santos64421833santos
sartor6313873sartor
station72717243station
stator64015473sta_tor
taboos83815423taboos
tabor75518393ta_bor
taco67031353ta__co
tacos77023553ta_cos
tact67349033tact__
tactic10612753tactic
taction93213023taction
tacts76524123tact_s
tailor63412503tailor
talion6317713talion
tallol63612223tallol
tallow93714203tallow
talon55824113ta_lon
tampon102911233tampon
tandoor8278563tandoor
tango66921173ta_ngo
tangos74216303tangos
tannoy958353tannoy
tantra63713353tantra
tao38358953ta___o
taos45541003ta__os
tapalo839793tapalo
taproom1147963taproom
taproot9412673taproot
tardo65321103ta_rdo
taro46846913ta__ro
taroc75721643ta_roc
tarok97921073ta_rok
taros55640823ta_ros
tarot55943933ta_rot
tarots66422993tarots
tarpon82812803tarpon
tart47566183tart__
tartan64217513tartan
tartar63214753tartar
tarted74923373tarted
tarter64023563tarter
tartly96014023tartly
tarts57242023tart_s
tarty86328183tart_y
taste55127233tast_e
tasted74123973tasted
taster64930573taster
tastes64126423tastes
tasty84820313tast_y
tat37690293ta_t__
tatami839183tatami
tatar56122063ta_tar
tatars64619793tatars
tate44748603ta_t_e
tater54138613ta_ter
taters64932193taters
tates55444983ta_tes
tats46858133ta_t_s
tatsois748373tatsois
tatters74520483tatters
tattier74216243tattier
tatties74120343tatties
tattily10409993tattily
tatting84019523tatting
tattled84311483tattled
tattler73112213tattler
tattles73616283tattles
tattooers943633tattooers
tattooing1043963tattooing
tattooist994813tattooist
tauon54816583ta_uon
taut47048963taut__
tauted75317113tauted
tauten64311893tauten
tauter64318023tauter
tautly9499503tautly
tautogs875413tautogs
tauts56125513taut_s
taxol124011363ta_xol
taxon124414663ta_xon
teston6313303teston
testoon748363testoon
tetter64322453tetter
tictoc1036003tictoc
tiptoe838283tiptoe
tiptop1036103tiptop
titter63421163titter
tittie63213153tittie
tittle63613323tittle
tittup834203tittup
titty85316653titt_y
too38965423___too
totted74319953totted
totter65021463totter
tractor9311333tractor
traitor7310123traitor
triton63914893triton
tutor5712493t_utor
tutted75117443tutted
tutti54614673tutt_i
tuttis63611373tuttis
tutty85217023tutt_y
twattle1064273twattle
vatted104214733vatted
wahoo112413083wa_hoo
wanton94413813wanton
watt75545413watt__
watter93221983watter
wattle94314213wattle
watts86923093watt_s
wazoo173011173wa_zoo
wittol935923wittol
yahoo112911543ya_hoo
yatter94116213yatter

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 Filter1786911127160.1531167915.0
2DLD Change Limit1127162917.01616065.6
3Display Results2912910.0933129.0
 (SQL Overall)1786912917.26224606.3
 
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.