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

138 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
tarantas83919(None) 
marantas10310021marantas
maranta9311692maranta_
taramas9612702tara_mas
tarantases1044892tarantases
tarantism1146232tarantism
tarantist948912tarantist
tarantulas1052872tarantulas
tartanas8258892tartan_as
tyrants1037452tyrant_s
alants67722023_alant_s
amanitas1048533_amanitas
amaranths1443553amaranths
antas55432033___antas
arenas65021993_aren_as
aristas7413523_aristas
asanas6514113_asan_as
ataraxias1644313ataraxias
atlantes838553atlantes
balatas9311833bala_tas
bananas93312223banan_as
baristas1039723baristas
barrancas1345093barrancas
barytas12378283bar_ytas
brants85723053_brant_s
cabanas112413033caban_as
canastas1037693canastas
carates95630613cara_tes
carats85929023cara_t_s
carinas93622413carin_as
caritas93316963car_itas
corantos10310103corantos
errants7410643errant_s
erratas736863erra_tas
farinas103215243farin_as
farinhas14325363farinhas
galangas1046173galangas
gargantuas1251733gargantuas
gazanias1845733gazanias
granitas92610223_granitas
grants73722473_grant_s
guaranas995943guaran_as
harianas1139163harian_as
infantas11246003infantas
jacanas1638263jacan_as
jarinas143712193jarin_as
jurants14379213jurant_s
karates115617473kara_tes
karats106420493kara_t_s
magentas1137923magentas
malangas1136863malangas
mananas93414733manan_as
mantas85725363__mantas
maracas11313773mara_cas
maranathas1552253maranathas
marascas1247383marascas
marinas93519393marin_as
naganas847983nagan_as
parangs104314373paran_gs
paranoeas1147523paranoeas
paranoias11410443paranoias
parental10310943parental
parents93418123parent_s
partitas10310253partitas
piranas9912603piran_as
piranhas13135873piranhas
puranas9712643puran_as
raitas64417673__raitas
rants55935343__rant_s
sarans64224433saran__s
sardanas937823sardan_as
savannas1143733savannas
savants1038653savant_s
stratas73013583stra_tas
tabanids1144963tabanids
taenias7311283ta_enias
taffetas1442723taffetas
taggants1044933taggant_s
taints64520533ta_int_s
talents7312013talent_s
tamanduas1242573tamanduas
tamandus1143943tamandus
tamashas13135683tamashas
tankas104613763t__ankas
tannates81911953tannates
tantras73112093t__antras
tarama8412733tara_ma_
tarantellas1152063tarantellas
tarantisms1245533tarantisms
tarantists1055333tarantists
tarantula952893tarantula
tarantulae1052303tarantulae
targets84314223target_s
tarlatan845063tarlatan
tarlatans944353tarlatans
tarletan845543tarletan
tarletans944653tarletans
tarnal63716503tar_n_al
tarns56433953tar_n__s
tarots66422993tar_ot_s
tarpans92513533tarpan__s
tarsias74013373tar_sias
tartan64217513tar__tan
tartana73010193tartan_a_
tartans72615823tar__tans
tartar63214753tar__tar
tartars73313403tar__tars
tartness82210133tartness
tarts57242023tar__t_s
tarzans16329923tarzan__s
taunts65715663ta_unt_s
tenants7311013tenant_s
titanias847103titanias
titrants838483titrant_s
tortas64918253tor__tas
tracts85019073t_ract_s
traits65121983t_rait_s
trances93919643t_rances
trangam1039353t_rangam
trangams1147203t_rangams
tranks104017763t_ran_ks
tranqs155210313t_ran_qs
trans54933043t_ran__s
traumas938593t_raumas
tronas63816903t_ron_as
truants738163truant_s
tsarinas835273tsarin_as
turistas846693turistas
tyrant9315333tyrant__
tzarinas1733973tzarin_as
uranias72113813_uranias
vagrants1246143vagrant_s
variants1139203variant_s
varnas94212823var_n_as
verandas1246233verandas
wakandas1643413wakandas
warrants1168503warrant_s
zananas16319563zanan_as

Search took 8 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621386.64022012.3
3Display Results1381380.0463000.0
 (SQL Overall)1786911387.10925135.9
 
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.