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

236 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
tattoos73864(None) 
tattoo6310971tattoo_
dattos74311902datt_os
rattons73815322rattons
rattoon7359242rattoon
rattoons8327512rattoons
taboos83815432ta_boos
tatsois748372tatsois
tatters74520482tatters
tatties74120342tatties
tattles73616282tattles
tattooed944572tattooed
tattooer844372tattooer
tattooers943632tattooers
tattooist994812tattooist
tautogs875412tautogs
actors81016763_actors
altos55822953_alt_os
anattos7138453anatt_os
atoms76817563_a_toms
attars64515313_attars
attics84413283_attics
attorn6310793_attorn
attorns738443_attorns
autos56523323_aut_os
baboos103517013ba_boos
bamboos1348753bamboos
batboys1465833batboys
bathos116215633ba_thos
batons85519423ba_tons
battens95313263battens
batters94626013batters
battiks1337143battiks
battles94517683battles
batts76727563batt__s
battues94610193battues
bazoos173212623ba_zoos
bettors93312473bettors
bottoms1136993bottoms
buttons9310333buttons
cantons95221203cantons
cantors94620753cantors
cantos84826973cant_os
captors113914983captors
cartons94122473cartons
cartoon94114463cartoon
cartoons104012803cartoons
cashoos12310793cashoos
castors94919443castors
catalos9414163catalos
cations94524143cations
cattalos1037933cattalos
catties94023053catties
cottons9312193cottons
daltons8310403daltons
datos65222783da_t_os
datto65416423datt_o_
dittos74111973ditt_os
factors12912123factors
fantods11177623fantods
fantoms12189153fantoms
fathoms1537523fathoms
fatsoes10379423fatsoes
fatsos9389423fa_tsos
fattens105111713fattens
fatties103018203fatties
fatuous1037783fatuous
fatwood1486393fatwood
fatwoods1585953fatwoods
flattops1344553flattops
gators74115833ga_tors
gazoos163010223ga_zoos
gentoos838633gentoos
haftoros1444173haftoros
halloos103716743halloos
hatters104221523hatters
jatos125116823ja_t_os
jettons1437273jettons
karoos102415803ka_roos
karroos1139313karroos
kations114013663kations
kazoos19259113ka_zoos
laptops1166603laptops
latigos8277243latigos
latinos73613803latinos
lattens75014673lattens
lattes65324203latt_es
lattins74115483lattins
lottos64613103lott_os
madtoms1236923madtoms
maltols939403maltols
matrons93517633matrons
matters94421753matters
mattes85624533matt_es
mattins93316143mattins
mattock1535823mattock
mattocks1644983mattocks
mattoid1079283mattoid
mattoids1196183mattoids
matts76829183matt__s
matzohs2134373matzohs
matzoon1896473matzoon
matzoons19105083matzoons
matzos1749263ma_tzos
mottoes93412193mottoes
mottos84615243mott_os
muttons949283muttons
nations74720563nations
natrons73215663natrons
natters73718063natters
ottos54714323_ott_os
pantos85222743pant_os
partons94620513partons
partook1337313partook
pastors94119003pastors
pathos115516693pa_thos
patios85221783pa_tios
patois84319363pa_tois
patrols93513513patrols
patrons93818103patrons
patroon92811973patroon
patroons102710603patroons
pattens95414923pattens
patters94825193patters
patties93425143patties
pottos84615873pott_os
ragtops1035453ragtops
raptors94213353raptors
rations74123433rations
ratios64922673ra_tios
ratoon64417373ra_toon
ratoons73815473ratoons
ratos55528763ra_t_os
rattans73411953rattans
rattens74213403rattens
ratters74422473ratters
rattles73217303rattles
ratton64116123ratt_on
santols73513323santols
santoor737433santoor
santoors837633santoors
santos64421833sant_os
sartors7314973sartors
stations82415223stations
stators73915583sta_tors
taboo73418093ta_boo_
tabors84517113ta_bors
tacos77023553ta__cos
tactics1149323tactics
taction93213023taction
tactions102912423tactions
tacts76524123tact__s
tailors73212393tailors
talcous939483talcous
talions7314113talions
tallols73311363tallols
tallows103313743tallows
talons64019443ta_lons
tampons112711563tampons
tandoor8278563tandoor
tandoors9258053tandoors
tangos74216303ta_ngos
tannoys1055553tannoys
tanto55724943tant_o_
tantras73112093tantras
taos45541003ta___os
tapalos938813tapalos
taproom1147963taproom
taprooms1246663taprooms
taproot9412673taproot
taproots1047253taproots
tarboosh1343143tarboosh
tarocs84615663ta_rocs
taroks106115283ta_roks
taros55640823ta__ros
tarots66422993ta_rots
tarpons92612213tarpons
tartans72615823tartans
tartars73313403tartars
tarts57242023tart__s
tasters74225643tasters
tastes64126423tast_es
tatamis939723tatamis
tatars64619793ta_tars
taters64932203ta_ters
tates55444983ta_t_es
tats46858133ta_t__s
tatsoi637263ta_tsoi
tatted74920533tatt_ed
tatter64024573tatt_er
tattie64817513tatt_ie
tattier74216243tattier
tattiest83415383tattiest
tattily10409993tattily
tatting84019523tatting
tattings9408823tattings
tattle64115653tatt_le
tattled84311483tattled
tattler73112213tattler
tattlers8369693tattlers
tattooing1043963tattooing
tattooists1092743tattooists
tatty84720183tatt__y
tauons63412673ta_uons
tautens7317843tautens
tautog765713taut_og
tauts56125513taut__s
taxols13328633ta_xols
taxons134211503ta_xons
testons7313563testons
testoon748373testoon
testoons837323testoons
tetters74320473tetters
tictocs1145903tictocs
tiptoes939173tiptoes
tiptops1136073tiptops
titters74219623titters
titties73617363titties
tittles73413253tittles
tittups933353tittups
totters74618733totters
tractors10312563tractors
traitors8310793traitors
tritons73814883tritons
tutors6912333t_utors
tutties73216473tutties
tuttis63611373tutt_is
twattles1154383twattles
wahoos122310593wa_hoos
wantons103713013wantons
wattles103814073wattles
watts86923093watt__s
wazoos18288553wa_zoos
wittols1035733wittols
yahoos12209243ya_hoos
yatters103914623yatters

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.403443402.0
2DLD Change Limit1340272366.20621596.4
3Display Results2362360.0932537.6
 (SQL Overall)1786912366.70226662.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.