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

195 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
tatamis93972(None) 
tatami839191tatami_
salamis9313512salamis
tamaris9413602tamaris
tamis76728732__tamis
taramas9612702taramas
tatars64619792tata_rs
tatsois748372tatsois
abamps1236253_abamps
abatis84317933_abatis
agamas97413453_agamas
agamic113110563_agamic
agamid103710693_agamid
agamids11317013_agamids
alamos8415003_alamos
amis66445323___amis
animis84615943_animis
arames84622573_arames
aramid93315613_aramid
aramids102810513_aramids
ataman81013063_ataman
atamans9710433_atamans
ataps76414833_ata_ps
atavic11189293_atavic
atavism1238033_atavism
atavist10311093_atavist
ataxia13179593_ataxia
ataxias14189343_ataxias
ataxic15169203_ataxic
ataxics16196643_ataxics
ataxies142410013_ataxies
atmans84413963_atmans
atmas75721013_at_mas
atomic104115603_atomic
atomics113110853_atomics
atomies93918363_atomies
atomise93013823_atomise
atomism112610963_atomism
atomist92915763_atomist
atoms76817563_atom_s
attacks13126943attacks
attain6311753atta_in
attains7310983attains
attars64515313atta_rs
bantams1149063bantam_s
bayamos1434663bayamos
calami10313423calami_
calamus1139243calamus
catalos9414163catalos
catamite12510593catamite
catamites1349363catamites
dalasis8810533dalasis
dataries9314033dataries
datums936353datum_s
degamis11268443degamis
ectasis9249613ectasis
entasis73012573entasis
etamin81311853_etamin
etamins91511833_etamins
fatalism13310483fatalism
fatalist11314973fatalist
kalams12310603kalam_s
katas95922093kata__s
lactams1136953lactam_s
lanais6316793lana_is
latakia1146093latakia
latakias1245583latakias
lathis95516173lat_his
madames12310063madames
madams11310943madam_s
pajamas18278153pajamas
palais8420423pala_is
panamas113112763panamas
paramos113213513paramos
pastramis1345683pastramis
patacas11311003patacas
patagia1068783patagia
patamar1147093patamar
patamars1246843patamars
patois84319363pat_ois
potamic13310853potamic
ratafia1045773ratafia
ratafias1145323ratafias
ratals64219583rata_ls
ratanies8312923ratanies
ratans63819373rata_ns
safaris101110663safaris
salami8313103salami_
salmis8514273sa_lmis
satangs8479713satangs
satanic939933satanic
satanism1039673satanism
satanist8313373satanist
sataras7315063sataras
satays94411683sata_ys
satis55633683sat__is
satoris7317253satoris
stamps105614023_stamps
stasis63116873_stasis
swamis114212293_swamis
tabanid1047333tabanid
tabanids1144963tabanids
tabards10310383tabards
tabbis102910863ta_bbis
tabulis938833tabulis
tahinis1048013tahinis
takahes1436173takahes
takas95520683taka__s
talaria7412523talaria
talars66021683tala_rs
talas55935893tala__s
tallis63319963ta_llis
tamales93216153tamales
tamals84116633tama_ls
tamari8313413tamari_
tamarin9311923tamarin
tamarins10310843tamarins
tamarisk1445473tamarisk
tames75242013__tames
tammie104212693ta_mmie
tammies113814683ta_mmies
tamps95524093__tamps
tams67247933__tam_s
tantalic1048053tantalic
tantalise91210823tantalise
tantalus836373tantalus
tantaras8269543tantaras
tanukis1134713tanukis
tapalos938813tapalos
tapas74627713tapa__s
tapis75028863__tapis
tarama8412733taram_a
tarmacs1138323tarmacs
tartanas8258893tartanas
tartans72615823tarta_ns
tartaric1047063tartaric
tartars73313403tarta_rs
tatar56122063tata__r
taters64932203tat_ers
tates55444983tat__es
tats46858133tat___s
tatsoi637263tatsoi_
tatters74520483tatters
tattie64817513tat_tie
tatties74120343tatties
tattles73616283tattles
tattoos738643tattoos
tautaugs9162483tautaugs
taxemes1635853taxemes
taxemic1835243taxemic
taxis126821973__taxis
teams75726513t_eam_s
teatimes1039443teatimes
terais64023513tera_is
tetanic9810133tetanic
tetanics10127373tetanics
tetanies8513553tetanies
tetanise8610203tetanise
tetanus737933tetanus
tetris62816293tet_ris
thalami1246083thalami_
thalamic1545553thalamic
thalamus1343603thalamus
thiamin1236933thiamin
thiamins1346633thiamins
tiramisu1045123tiramisu
titania738293titania
titanias847103titanias
titanic968553titanic
titanism1048213titanism
titans63414913tita_ns
titis56023813tit__is
totalise8312503totalise
totalism10311093totalism
totalist8315583totalist
totals63115163tota_ls
totemic1137533totemic
totemism1245433totemism
totemist1049033totemist
totems86810763totem_s
tramps105114453t_ramps
trams75327673t_ram_s
tsadis7429133t_sadis
tsunamis1042403tsunamis
tuataras844863tuataras
tuladis835703tuladis
tuttis63611373tut_tis
uakaris1146633uakaris
umamis1038273_umamis
vitamin1237423vitamin
vitamins1347083vitamins
wakames1635283wakames
wasabis1255363wasabis
watapes12228383watapes
wataps11248683wata_ps

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.390458182.1
2DLD Change Limit1340271956.47020715.1
3Display Results1951950.0762565.8
 (SQL Overall)1786911956.93625762.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.