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

214 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
tatsoi63726(None) 
tatsois748371tatsois
fatso85113492fatso_
fatsos9389422fatsos
tarsi55222172tars_i
tatami839192tatami
tats46858132tats__
tattoo6310972tattoo
also46423443_also_
arson55118833_arson
asci66519143_a_sci
askoi9507803_askoi
assai5711543_assai
assoil688543_assoil
atom67824523_at_om
atop66124753_at_op
bassi77019323ba_ssi
basso76017283basso_
bassos85313703bassos
batboy1387533batboy
bathos116215633bathos
baton75822423bat_on
bats66962333bats__
canso75019403canso_
cansos84915383cansos
castor84418533castor
cation83925503cation
cats66356343cats__
catsuit959393catsuit
catsup1036433catsup
cestoi84511953cestoi
damson938063damson
dashi95013113da_shi
dato56129943dat_o_
datos65222783dat_os
datto65416423datto_
dattos74311903dattos
eats47054873eats__
fathom1437473fathom
fats76252503fats__
fatsoes10379423fatsoes
gator64416043gat_or
gats56753443gats__
hansom11219153hansom
hatbox1835133hatbox
hats76858253hats__
jato115822683jat_o_
jatos125116823jat_os
jetsom15126143jetsom
kation104315683kation
kats85944333kats__
lassi56316853la_ssi
lasso55015683lasso_
lassos64913813lassos
lathi85417203lat_hi
lati46438273lat__i
latosol745283latosol
lats45962703lats__
mason74820183ma_son
mastoid10711233mastoid
matron83918313matron
mats65460293mats__
matsah1138233matsah
mattoid1079283mattoid
matzo16312893matzo_
matzoh2035483matzoh
matzos1749263matzos
matzot17710983matzot
mythoi14417143mythoi
naoi46024633na__oi
nation64322803nation
natron64116023natron
oats46554213oats__
octroi837363octroi
parson83817903parson
pastor84817483pastor
pathos115516693pathos
patio74426353patio_
patios85221783patios
patois84319363pat_ois
patrol83213023patrol
patron84018043patron
pats66460853pats__
patsy105717203pats_y
petsai838083petsai
qats135331343qats__
ramson8310463ramson
ransom82410943ransom
ratio55227583ratio_
ration64226013ration
ratios64922673ratios
rato45436973rat_o_
ratoon64417373ratoon
ratos55528763rat_os
rats46260373rats__
ratton64116123ratton
sansei63411903sansei
sati45539333sat__i
satori6415843satori
station72717243station
stator64015483stat_or
stats55933363stats__
stetson745783stetson
tabloid1048263tabloid
taboo73418093ta_boo
taboos83815433taboos
tabor75518393ta_bor
tabs66842983tabs__
tabuli839363tabuli
taco67031353ta_co_
tacos77023553ta_cos
taction93213023taction
tacts76524123tacts__
tads57143943tads__
tags55545233tags__
tahini939893tahini
tahsil936343tahsil
tailor63412503tailor
tali46837163ta__li
talion6317713talion
tallol63612223tallol
tallow93714203tallow
talon55824113ta_lon
tamari8313413tamari
tampon102911233tampon
tams67247933tams__
tango66921173tango_
tangos74216303tangos
tannoy958353tannoy
tans46154823tans__
tansy84514933tans_y
tanto55724943tanto_
tanuki1034913tanuki
tao38358953ta__o_
taos45541003ta__os
taps66050673taps__
tardo65321103tardo_
taro46846913ta_ro_
taroc75721643ta_roc
tarok97921073ta_rok
taros55640823ta_ros
tarot55943933ta_rot
tarpon82812803tarpon
tars46763953tars__
tarsal63315273tarsal
tarsia65514273tarsia
tarsus6310513tarsus
tarts57242023tarts__
tas38477103ta_s__
task85326653ta_s_k
tasks94917583ta_sks
tass45640573ta_s_s
tasse54821843ta_sse
tassel66014773tassel
tasses64826763tasses
tasset65925313tasset
tassie66017023tassie
taste55127233ta_ste
tasted74123973tasted
taster64930573taster
tastes64126423tastes
tasty84820313ta_sty
tat37690293tat___
tatamis939723tatamis
tatar56122063tat_ar
tatars64619793tatars
tate44748603tat__e
tater54138613tat_er
taters64932203taters
tates55444983tat_es
tatted74920533tatted
tatter64024573tatter
tattie64817513tattie
tattle64115653tattle
tattoos738643tattoos
tatty84720183tat_ty
tauon54816583ta_uon
taus46342733taus__
tautog765713tautog
tauts56125513tauts__
tavs75630973tavs__
taws75641593taws__
tawse85616503taws_e
tawsed10499743tawsed
tawses94913193tawses
taxi117124763ta__xi
taxol124011363ta_xol
taxon124414663ta_xon
teats55636813teats__
teloi54217383t_eloi
telson6310293telson
tensor63812673tensor
teston6313303teston
tetri52716453tet_ri
tets45847463tets__
tholoi9339233tholoi
titi47130623tit__i
tits46145043tits__
topoi76018353t_opoi
topsoil977143topsoil
torsi57423363tors_i
torso56922143torso_
torsos64815733torsos
tots46654123tots__
transom948823transom
tsatske1141833tsatske
tussor6378233tussor
tutor5712493tut_or
tuts45838453tuts__
tutti54614673tut_ti
twats86616603twats__
vats76841743vats__
wats77555883wats__
xystoi16365133xystoi

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.376475242.0
2DLD Change Limit1127162145.59320153.0
3Display Results2142140.0633396.8
 (SQL Overall)1786912146.03229623.8
 
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.