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

203 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
tatami83919(None) 
tatamis939721tatamis
calami10313422calami
salami8313102salami
tamari8313402tamari
tarama8412732tarama
tatar56122062tata_r
tatars64619792tatars
tatsoi637262tatsoi
thalami1246082thalami
abaci94718843_abaci
abamp11310603_abamp
acari75020283_acari
agama85815583_agama
agamic113110563_agamic
agamid103710693_agamid
alamo7418143_alamo
ami56646813___ami
animi74016663_animi
arame75026623_arame
aramid93315613_aramid
ataman81013063_ataman
atap66722453_ata_p
ataps76414833_ataps
atavic11189293_atavic
ataxia13179593_ataxia
ataxic15169203_ataxic
ataxy1537313_ataxy
atma68121773_at_ma
atman75520143_atman
atmas75721013_atmas
atom67824523_atom_
atomic104115603_atomic
atoms76817563_atoms
atomy107415193_atomy
attach11118393attach
attack12148153attack
attain6311753attain
attar56516693atta_r
attars64515313attars
bantam10314063bantam_
bantams1149063bantams
batman105214063batman
bayamo1335603bayamo
catalo8314853catalo
catamite12510593catamite
dalasi7610623dalasi
data56026653data__
datary10310243datary
datum8310633datum_
datums936353datums
degami10279013degami
etamin81311853_etamin
fatal84819373fata_l
isthmi1143603isthmi
kalam11315113kalam_
kalams12310603kalams
kami105823643__kami
kata85626023kata__
katas95922093kata_s
laari54415713la_ari
lactam10310943lactam_
lactams1136953lactams
lanai5319573lana_i
latakia1146093latakia
lathi85417203lat_hi
lati46438273lat__i
litai55216363lita_i
madam10316223madam_
madame1139853madame
madams11310943madams
natal53921493nata_l
natant6318733natant
pajama17317653pajama
panama104213353panama
paramo102614643paramo
pastrami1246333pastrami
pataca10311193pataca
patagia1068783patagia
patamar1147093patamar
potamic13310853potamic
rami66034093__rami
ratafia1045773ratafia
ratal55025113rata_l
ratals64219583ratals
ratan53722663rata_n
ratans63819373ratans
ratany93411873ratany
safari91110223safari
salamis9313513salamis
salmi7815863sa_lmi
santimi938793santimi
satang75711563satang
satanic939933satanic
satara6315533satara
satay84718463sata_y
satays94411683satays
satem76021463satem_
sati45539333sat__i
satori6415843satori
stamp95217363_stamp
statal61613223stata_l
statant7313123statant
swami105614523_swami
tabanid1047333tabanid
tabard9313333tabard
tabuli839363tabuli
tahini939893tahini
taka87623593taka__
takahe1335793takahe
takas95520683taka_s
tala45938053tala__
talar56225383tala_r
talaria7412513talaria
talars66021683talars
talas55935893tala_s
tali46837163__tali
tam58663423__tam_
tamal73522623tama_l
tamale83717403tamale
tamals84116633tamals
tamarin9311913tamarin
tamaris9413593tamaris
tame66343663__tame
tamis76728733__tamis
tammie104212693ta_mmie
tammy124013223ta_mmy
tamp86133003__tamp
tams67247933__tams
tantalic1048053tantalic
tantara72410823tantara
tanuki1034913tanuki
tapa65129143tapa__
tapalo839793tapalo
tapas74627713tapa_s
taramas9612703taramas
tarmac10310333tarmac
tarsi55222173ta_rsi
tartan64217513tarta_n
tartana73010193tartana
tartans72615823tartans
tartar63214753tarta_r
tartare73012683tartare
tartaric1047053tartaric
tartars73313403tartars
tat37690293tat___
tate44748603tat__e
tater54138613tat_er
taters64932203taters
tates55444983tat_es
tats46858133tat__s
tatsois748373tatsois
tatted74920533tatted
tatter64024573tatter
tattie64817513tattie
tattle64115653tattle
tattoo6310973tattoo
tatty84720183tat_ty
tautaug883023tautaug
taxa116820093taxa__
taxeme1536253taxeme
taxemic1835243taxemic
taxi117124763__taxi
taxman15328613taxman
team66238653t_eam_
teams75726513t_eams
teatime9310083teatime
terai53525483tera_i
tetanic9810133tetanic
tetany959843tetany
tetri52716453tet_ri
thalamic1545553thalamic
thiamin1236933thiamin
thymi13418633t_hymi
titan53318173tita_n
titania738293titania
titanic968553titanic
titans63414913titans
titi47130623tit__i
titman82711003titman
total55321823tota_l
totals63115163totals
totem74819373totem_
totemic1137533totemic
totems86810763totems
tragi64717173t_ragi
tram67034553t_ram_
tramp96319773t_ramp
trams75327673t_rams
tsadi6379913t_sadi
tsunami943033tsunami
tuatara745513tuatara
tuladi765723tuladi
tutti54614673tut_ti
uakari1046863uakari
umami939883_umami
untame82513603untame
vitamin1237423vitamin
wakame1535433wakame
wasabi1154643wasabi
watap102111673wata_p
watape11208483watape
wataps11248683wataps

Search took 6 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.373479064.3
2DLD Change Limit1127162034.90622975.1
3Display Results2032030.0633222.2
 (SQL Overall)1786912035.34233450.2
 
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.