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

253 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
teargas83701(None) 
taigas73712562t_aigas
targes74524592t_arges
tearers75218232tearers
teargases1044802teargases
tears55436462tear__s
telegas837442telegas
terga63315642te_rga_
tergal72912832te_rgal
terras63516972te_rras
tetras63017622tetr_as
tiaras6314552tiar_as
agas55938843__a_gas
algas65624933__algas
angas65827983__angas
areas55935773__areas
argal65023393__argal
argals75517713__argals
argus66716543__argus
arias55438023__arias
arras55626133__arras
avgas96912133__avgas
barcas101016603_barcas
barges94528253_barges
bearcat11611913bearcat
bearcats1267023bearcats
beards94116673bear_ds
bearers94619593bearers
beargrass1252923beargrass
bears75739043bear__s
belgas9311713be_lgas
belugas1035903belugas
bergs84718043be_rg_s
cargos94619183_cargos
cerias83321983ce_rias
charas114223613char_as
charges134615983charges
charkas164810963charkas
czardas1934673czardas
daggas937973_daggas
dearies83526273dearies
dears65736883dear__s
dearths11498843dearths
defrags1236193defrags
degas75119163de__gas
dermas94116813de_rmas
dharmas1356513dharmas
dharnas1155373dharnas
eagres74014573_eagres
earlap837183_earlap
earlaps936393_earlaps
earls56127513_ear_ls
earns55927563_ear_ns
ears46356593_ear__s
earths95014593_earths
earwax1664733_earwax
eras45441503_e_r_as
ergs55523813_e_rg_s
eyras84715923_eyr_as
fangas105017193_fangas
fearers104815273fearers
fears84829393fear__s
ferias95020393fe_rias
gearcase1154453gearcase
gears64628693gear__s
hearers104319783hearers
hears86737373hear__s
hearsay1335523hearsay
hearsays1444513hearsays
hearses104414533hearses
hearths135311073hearths
hearts96218943hear_ts
jagras1438463_jagras
karmas123013733_karmas
kerrias11289513kerrias
larges74824233_larges
largos74815063_largos
larvas9310233_larvas
learns65513743lear_ns
lears55938733lear__s
mangas94122923_mangas
maras75443293_mar_as
margay12310593_margay
margays1337493_margays
marges94525713_marges
markas124717003_markas
merges94122493me_rges
nears55529423near__s
pangas99921103_pangas
paras76143043_par_as
parges94529543_parges
pargos95719043_pargos
parkas125018023_parkas
peages94321853pea_ges
peags86122843pea_g_s
pearlash1344133pearlash
pearls84715393pear_ls
pears75138613pear__s
quaggas1893703quaggas
ragas65326063_ra_gas
realgar834873realgar
realgars934533realgars
rearers74323563rearers
reargue836463reargue
reargues936713reargues
rearms85114653rear_ms
rears54739653rear__s
reatas64021013rea_tas
sagas66025883_sa_gas
saigas74114293_saigas
sangas75222653_sangas
sarges75128593_sarges
sargos74318273_sargos
seabags1037483seabags
sears54744913sear__s
senegas837253senegas
serges74225973se_rges
sevrugas1242153sevrugas
sharias102516003sharias
sparges104016343sparges
stearins8312143stearins
tablas83716163t_ablas
taenias7311283taenias
tafias93111963t_afias
tagrag837043t_agrag
tagrags936123t_agrags
tags55545233t_a_g_s
taiga64115663t_aiga_
takas95520683t_a_kas
talas55935893t_a_las
tanga64923693t_anga_
tangos74216303t_angos
tangs65028343t_ang_s
tankas104613763t_ankas
tapas74627713t_a_pas
taramas9612703t_aramas
tares57456563t_ar_es
targe65227093t_arg_e
target75028903t_arget
targets84314223t_argets
tarmac10310333t_armac
tarmacs1138323t_armacs
tarnal63716503t_arnal
tarns56433953t_ar_ns
tarocs84615663t_arocs
taroks106115283t_aroks
taros55640823t_ar_os
tarots66422993t_arots
tarpan82814293t_arpan
tarpans92513533t_arpans
tarps76527113t_ar_ps
tarres64723043t_arres
tars46763953t_ar__s
tarsal63315273t_arsal
tarsals72512603t_arsals
tarsias74013373t_arsias
tarsus6310513t_arsus
tartan64217513t_artan
tartans72615823t_artans
tartar63214753t_artar
tartars73313403t_artars
tarts57242023t_ar_ts
tarzan152910753t_arzan
tarzans16329923t_arzans
tazzas1436283t_azzas
teaches122718353teaches
teacups1133963teacups
teaks94222903tea__ks
teals56234133tea__ls
teams75726513tea__ms
teapots939053teapots
teapoys1235963teapoys
tear45242883tear___
tearaway1443693tearaway
tearaways1542973tearaways
teared75722153tear_ed
tearer64822903tear_er
tearful1046033tearful
teargassed1252153teargassed
teargasses1143063teargasses
tearier73815613tearier
teariest82417263teariest
tearily10311153tearily
tearing84021493tearing
tearless848713tearless
tearoom939063tearoom
tearooms1047843tearooms
teary85124053tear__y
teas45851493te___as
teasels74311313teasels
teasers75317243teasers
teases65426273tea_ses
teats55636813tea__ts
teazels16406893teazels
teazles16308923teazles
teggs74710743te__ggs
tegs56031493te__g_s
teguas768013te_guas
telega736773telega_
tenias64720073te_nias
tenrecs936033tenrecs
tepas76521683te__pas
tephras1236283tephras
terai53525483te_r_ai
terais64023513te_rais
terbias9310743terbias
terces83921413te_rces
tergum937933te_rgum
terms75523473te_r_ms
ternes65422903te_rnes
terns55226873te_r_ns
terra54419663te_rra_
terrae62915213te_rrae
terrets72913583terrets
terries73425633terries
territs72714503territs
terrors73112213terrors
teslas64212173te_slas
tetra53417953tetr_a_
tetrad73612053tetr_ad
tetrads82910193tetrads
tetris62816293tetr_is
tetryls1034643tetryls
texas126514933te__xas
tharms115712243thar_ms
thorias102312053thorias
tiara5315913tiar_a_
togas67823003t__ogas
tongas74315523t_ongas
toras55540373t_or_as
tortas64918253t_ortas
tragus749233tra_gus
trangam1039353trangam
trangams1147203trangams
traumas938593traumas
tsarinas835273tsarinas
tsars56717113tsar__s
twangs10358093twang_s
tzarinas1733973tzarinas
tzars144914273tzar__s
varas86028193_var_as
varias95019903_varias
varnas94212823_varnas
verges104320183ve_rges
verglas1137813ve_rglas
virgas1048883_virgas
wearers104615903wearers
wearies103020223wearies
wears86030303wear__s
yearns9509543year_ns
years84527673year__s
yerbas11119293ye_rbas
zebras1737853zebr_as

Search took 10 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.406440125.6
2DLD Change Limit1340272538.59315597.2
3Display Results2532530.0932720.4
 (SQL Overall)1786912539.09219653.7
 
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.