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

171 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
tatsois74837(None) 
tatsoi637261tatsoi_
fatsoes10379422fatsoes
fatsos9389422fatso_s
patois84319362pat_ois
tatamis939722tatamis
tattoos738642tattoos
apsis75718293_aps_is
arsis55722423_ars_is
arsons63917213_arsons
aspis74618143_a_spis
assais6711963_assais
assoil688543_assoil
assoils776663_assoils
atoms76817563_at_oms
basis75429863ba_s_is
bassos85313703basso_s
batboys1465833batboys
bathos116215633batho_s
batons85519423bat_ons
cansos84915383canso_s
cassis84818853ca_ssis
castors94919443castors
cations94524143cations
catsuit959393catsuit
catsuits1045433catsuits
catsups1135343catsups
damsons1038013damsons
dashis104414393da_shis
datos65222783dat_o_s
dattos74311903datto_s
fathoms1537523fathoms
fatso85113493fatso__
fatuous1037783fatuous
gaposis1038423gaposis
gators74115843gat_ors
hansoms12238523hansoms
hautbois1343103hautbois
jatos125116823jat_o_s
jetsoms16124723jetsoms
kations114013663kations
ketosis11429733ketosis
lassis65216703la_ssis
lassoes74613853lassoes
lassos64913813lasso_s
lathis95516173lat_his
latosols845003latosols
masons83916513ma_sons
mastoid10711233mastoid
mastoids1177873mastoids
matrons93517633matrons
matsahs1236563matsahs
mattoid1079283mattoid
mattoids1196183mattoids
matzohs2134373matzohs
matzos1749263matzo_s
mitosis939633mitosis
nations74720563nations
natrons73215663natrons
oasis56422553oa_s_is
octrois938343octrois
ostosis71310123ostosis
parsons93516873parsons
pastis84924323pa_stis
pastors94119003pastors
pathos115516693patho_s
patios85221793patio_s
patrols93513513patrols
patrons93818103patrons
patsies93919483patsies
petsais938433petsais
ptosis83611823_ptosis
ramsons939563ramsons
ransoms92410163ransoms
rations74123433rations
ratios64922673ratio_s
ratoons73815473ratoons
ratos55528773rat_o_s
rattons73815323rattons
sanseis73011603sanseis
satis55633683sat__is
satoris7317253satoris
stasis63116873sta_s_is
stations82415223stations
stators73915583stat_ors
stetsons845623stetsons
tabbis102910863ta_bbis
tabloid1048263tabloid
tabloids1146163tabloids
taboos83815433ta_boos
tabors84517113ta_bors
tabulis938833tabulis
tacos77023553ta_co_s
tactions102912423tactions
tahinis1048013tahinis
tahsil936343tahs_il
tahsils1035053tahsils
tailors73212393tailors
talcous939483talcous
talions7314113talions
tallis63319963ta_llis
tallols73311363tallols
tallows103313743tallows
talons64019443ta_lons
tamaris9413603tamaris
tamis76728733ta__mis
tampons112711563tampons
tangos74216323tango_s
tannoys1055553tannoys
tansies74521243tansies
tanukis1134713tanukis
taos45541003ta__o_s
tapis75028863ta__pis
tarocs84615663ta_rocs
taroks106115283ta_roks
taros55640823ta_ro_s
tarots66422993ta_rots
tarpons92612213tarpons
tarsals72512603tarsals
tarsi55222173tars_i_
tarsia65514273tars_ia
tarsias74013373tarsias
tarsus6310513tars_us
tasks94917583ta_s_ks
tass45640573ta_s__s
tassels74510853tassels
tasses64826763ta_sses
tassets75012773tassets
tassie66017023ta_ssie
tassies74918933tassies
tasters74225643tasters
tastes64126423ta_stes
tatami839193tatami_
tatars64619793tat_ars
taters64932203tat_ers
tates55444983tat__es
tats46858133tat___s
tatters74520483tatters
tattie64817513tat_tie
tatties74120343tatties
tattles73616283tattles
tattoo6310973tatto_o
tattooist994813tattooist
tauons63412673ta_uons
tautogs875413tautogs
tawses94913193taws_es
taxis126821973ta__xis
taxols13328633ta_xols
taxons134211503ta_xons
telsons739223telsons
tensors72712373tensors
testis64916713t_estis
testons7313563testons
tetris62816293tet_ris
thesis94913733thes_is
titis56023813tit__is
tmesis8529793tmes_is
topsoil977143topsoil
topsoils1095143topsoils
torsos64815733torso_s
transoms1048933transoms
travois1037883travois
trois57226093__trois
tsatskes1242013tsatskes
tsoris63411193__tsoris
turkois1135133turkois
tussis6379953t_ussis
tussors7388773tussors
tutors6912333tut_ors
tuttis63611373tut_tis
whatsis1335253whats_is

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.436409841.7
2DLD Change Limit1340271716.34321129.9
3Display Results1711710.0802137.5
 (SQL Overall)1786911716.85926052.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.