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

254 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
yantras1025900(None) 
mantras93815861mantras
tantras73112091tantras
yantra9449621yantra_
antas55432032_ant_as
antra56521922_antra_
antral65719412_antral
antres65021002_antres
cantrap113310272cantrap
cantraps12319112cantraps
contras93015602contras
kantars11310032kantars
mantas85725362mant_as
mantra84116092mantra_
mantram114011602mantram
mantrams12288962mantrams
mantrap11379822mantrap
mantraps12298062mantraps
mantuas93410992mantuas
santeras8311052santeras
tantaras8269532tantaras
tantra63713352tantra_
yautias1046332yautias
yentas94614212yent_as
agoras7613343_agoras
altars64518153_altars
amtrac10109123_amtrac
amtracs1198883_amtracs
anabas8314083_anabas
anas46649863_an__as
andros7313303_andros
anears63717183_anears
angas65827983_an_gas
angoras8811363_angoras
animas84418723_animas
anlas55626933_an_las
annas55824883_an_nas
anoas57226493_an_oas
anorak1038923_anorak
anoraks1137603_anoraks
anta46839583_ant_a_
antae56828293_ant_ae
antes56334323_ant_es
anthrax1757153_anthrax
antiar6317173_antiar
antiars7314623_antiars
antics84621453_antics
antis55033313_ant_is
antre55224523_antr_e
antrum8611313_antrum
antrums969173_antrums
ants47243473_ant__s
anural65714743_anural
anuran64313243_anuran
anurans73810553_anurans
anurias7312243_anurias
aortas65417783_aortas
arras55626133_a_rras
astral66919283_astral
astrals75515243_astrals
astray95615543_astray
atlas55821583_a_tlas
atmas75721013_a_tmas
attars64515313_attars
auras55932553_a_uras
bananas93312223bananas
bandas95120543ban_das
bandoras1138743bandoras
bantam10314063bant_am
bantams1149063bantams
banters94623113banters
banties94324763banties
bhangras1443683bhangras
caltrap11297933caltrap
caltraps12327253caltraps
cameras11313343cameras
canards10311203canards
canchas143212403canchas
caners84629193caner_s
cannas84518403can_nas
canolas9313993canolas
cantal84122033cant_al
cantalas104013523cantalas
cantals93919573cantals
cantatas103410083cantatas
canters94827723canters
canthal12410053canthal
canthus1248703canthus
cantinas102713773cantinas
cantles94721413cantles
cantons95221203cantons
cantors94620753cantors
cantos84826973cant_os
cantraip12326383cantraip
cantraips13255263cantraips
cantrip112910033cantrip
cantrips12318923cantrips
cants77036943cant__s
cantus85117763cant_us
canulas9312853canulas
canvas113813333can_vas
centas85020703cent_as
centra84113883centra_
central93114473central
centrals102712033centrals
centres93817123centres
contra83314693contra_
contrast102614783contrast
daturas838763daturas
entrap8710563_entrap
entraps9109763_entraps
extras13310223_extras
fanegas1145713fanegas
fangas105017193fan_gas
fantasm1236593fant_asm
fantast10311703fant_ast
fantasy1336153fant_asy
fantods11177623fantods
fantoms12189153fantoms
fatwas1249053fa_twas
ganjas14149113gan_jas
gantries91413783gantries
gantry103810113gantr_y
gastral8329553gastral
gastreas957243gastreas
haftaras14136073haftaras
hangars114313483hangars
hansas94616043han_sas
hantles104117513hantles
hants86335403hant__s
intros64215773_intros
jagras1438463ja_gras
juntas134210503junt_as
kanakas10327213kanakas
kanas95326913kan__as
kantar10311153kant_ar
katas95922093ka_t_as
kinaras1159093kinaras
lantanas838263lantanas
lanterns838303lanterns
latrias71913213la_trias
lauras63414333la_uras
madras94316423ma_dras
malthas1237913malthas
mananas93414733mananas
manas76240423man__as
mangas94122923man_gas
manias84029033man_ias
manilas93915873manilas
mannas85019803man_nas
manors84420883manor_s
manta75629903mant_a_
manteau937863manteau
manteaus1036383manteaus
mantels94515043mantels
mantes84430783mant_es
mantids103113623mantids
mantis83926033mant_is
mantles94820703mantles
mantric11311333mantric
mantua84412023mantua_
manures9313353manures
maras75443283ma__ras
matrass939393ma_trass
matres84522233ma_tres
mattrass1045853mattrass
matzas1749703ma_tzas
nairas6312773na_iras
nanas55928633nan__as
osetras737323osetras
pakoras1337473pakoras
panadas103312213panadas
panamas113112753panamas
pancreas1235393pancreas
pandas95521963pan_das
pandoras11310053pandoras
panduras1136943panduras
pangas99921103pan_gas
pangram1239023pangram
pangrams1337153pangrams
panties94230933panties
pantos85222743pant_os
pantries101817393pantries
pantry115014103pantr_y
pants76536923pant__s
paras76143043pa__ras
paruras9310533paruras
pastas85422873past_as
pintas85021393pint_as
qintars16268573qintars
raitas64417673rait_as
ranters73323643ranters
rants55935343rant__s
ranulas7311773ranulas
rattrap945263rattrap
rattraps1044813rattraps
ristras7311543ristras
sabras85116363sa_bras
samaras9312913samaras
sangars83116253sangars
sangas75222653san_gas
sangrias938373sangrias
sansars73313913sansars
santera7311303santera_
santerias9311833santerias
santeros8311193santeros
santims9312593santims
santirs7312963santirs
santols73513323santols
santos64421833sant_os
santurs7310763santurs
sataras7315053sataras
satrap86212553sa_trap
satraps95011643sa_traps
senoras72714953senoras
sutras64818583_sutras
tangram1038063tangram
tangrams1136153tangrams
tankas104613763tan_kas
tantara72410813tantara
tantric939573tantric
tantrism1048373tantrism
tantrum946683tantrum
tantrums1045113tantrums
tartars73313403tartars
tatars64619793ta_tars
tetras63017613_tetras
tundras857113tundras
ultras6310183_ultras
vandas103915993van_das
varas86028193va__ras
ventral103612173ventral
ventrals11299993ventrals
wanters104420093wanters
wantons103713013wantons
wants87932213want__s
xanthan1736013xanthan
xanthans1845693xanthans
yagers105114533yager_s
yairds10448023ya_irds
yangs95618693yan__gs
yanks125316573yan__ks
yanquis1943723yanquis
yards95324613ya__rds
yarners104312203yarner_s
yarns85621793ya__rns
yatters103914623yatters
yautia937243yautia_
yawners13367183yawner_s
yenta83917043yent_a_
yentes95517603yent_es
yttrias1044513y_ttrias
zananas16319563zananas
zanzas1487053zan_zas

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272547.34318252.3
3Display Results2542540.0803175.0
 (SQL Overall)1786912547.57923577.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.