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

296 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
aramids10281051(None) 
agamids11317011agamids
aramid93315611aramid_
acarids105312242acarids
agamid103710692agamid_
amids85627512__amids
arames84622572aram_es
araneids947742araneids
armies85123692ar_mies
aroids75118222ar_oids
barmaids1345942barmaids
braids95015692bra_ids
bromids12278602bromids
carabids1338192carabids
pyramids1645642pyramids
raids65827512_ra_ids
ramies84630462_ramies
ranids75118702_ranids
rapids94913892_rapids
aaliis6312903a_aliis
abamps1236253abam_ps
abasias9711013abasias
abatis84317933abati_s
acacias11510403acacias
acarid95017073acarid_
acetamids1443443acetamids
acids87121003__acids
acrasias1048893acrasias
acrasins1039973acrasins
adagios945513adagios
admits9411413a_dmits
afraid1049723afra_id_
agamas97413453agam_as
agamic113110563agami_c
agamous1037943agamous
agarics10319943agarics
aids57846353__a_ids
airmails1045273airmails
alameda1035493alameda
alamedas1145443alamedas
alamode1038153alamode
alamodes1148013alamodes
alamos8415003alam_os
alands75418373ala_nds
alanins7315803alanins
alcids94812293a_lcids
almuds9378773a_lmuds
alumins9512983alumins
amias75831473__amias
amid77036353__amid_
amide86128483__amide
amides95722663__amides
amido85720983__amido
amidst94913233__amidst
amies76837693__amies
amins75534323__amins
amirs75924923__amirs
amis66445323__ami_s
amiss75823073__amiss
anaemias1069203anaemias
anemias92512143anemias
animis84615943animi_s
anomies93316993anomies
antacids1148333antacids
aphids125110843a_phids
apraxias1746333apraxias
arabic10312733arabi_c
arabica1147283arabica
arabicas1247193arabicas
arabize1849343arabize
arabizes1969103arabizes
arables91814973arables
arachnids1574303arachnids
araks94820883ara__ks
arame75026623aram__e
araneid8310803araneid_
arcadias1149163arcadias
archils12510533archils
arctics1138953arctics
argalis84214193argali_s
argils75213623ar_gils
arias55438023ar__ias
arid57642713ar__id_
arils58732203ar__ils
armada938783ar_mada
armadas1038173armadas
armed86324433ar_med_
armers85520273ar_mers
armets84918353ar_mets
arming94719803ar_ming
armings103811503ar_mings
armors85017813ar_mors
armpits1157133armpits
arms66137493ar_m__s
aroid65428343ar_oid_
aromas81018613arom_as
arris56824683ar_ri_s
arshins10312573arshins
arsis55722423ar_si_s
arums75517833arum__s
ascarids11438503ascarids
asramas938303asram_as
atamans9710433atamans
ataxias14189343ataxias
ataxics16196643ataxics
ataxies142410013ataxies
atomics113110853atomics
atomies93918363atomies
avails939693ava_ils
avoids104410203a_voids
awaits96411953awa_its
awards107113453awa_rds
barmaid1238203barmaid_
brads85528293bra__ds
braid85822263bra_id_
brails84621293bra_ils
brains85125473bra_ins
brands95118943bra_nds
brasils9410973brasils
braxies16711463braxies
brazils1867753brazils
bromid112612893bromid_
bromide12269583bromide
bromides13219363bromides
bromins112513783bromins
caids85226423_ca_ids
canids95118133_canids
carabid12311333carabid_
carabins12312353carabins
caramels1238803caramels
carangids1344573carangids
carbamide1645743carbamide
carbamides1745133carbamides
carotids11229943carotids
caryatids1545223caryatids
ceramics1446803ceramics
ceramide1347973ceramide
ceramides1447453ceramides
characids1745263characids
cosmids1237633cosmids
crambes1339963crambes
crambos1336783crambos
crampits1436273crampits
cramps125615563cram_ps
crams96229153cram__s
crasis85020473crasi_s
crazies183413853crazies
cyanamids1743163cyanamids
cyanids13297933cyanids
desmids1166603desmids
diacids1137863diacids
diamide1138473diamide
diamides1238823diamides
diamins10312213diamins
drails74716953dra_ils
drains73719403dra_ins
dramady1443553dramady
dramas95814653dram_as
dramedy1433243dramedy
drams86025833dram__s
droids84712583dr_oids
druids8368093dr_uids
elapids1036503elapids
etamins91511833etamins
farads104713273fara__ds
frails93716473fra_ils
framed125116523framed_
framers125113823framers
frames115119863fram_es
framing133014793framing
framings14338133framings
frauds1036753fra_uds
frazils1956123frazils
gadids95611823_gadids
gamins94420043_gamins
gradins93416233gradins
grads75625753gra__ds
grails77518783gra_ils
grains74223093gra_ins
gramas94317203gram_as
grammas12499773grammas
grammes123611323grammes
grampas12399253grampas
gramps114114273gram_ps
grampus12356313grampus
grams85327313gram__s
grands84218243gra_nds
gratins84119183gratins
gratis74819243grati_s
gravid113710983gravid_
gravida12366563gravida
gravidas13285803gravidas
gravies11314093gravies
grids75321393gr__ids
halids104016133_halids
harmins123716723har_mins
imids86015143__imids
irids66417773ir__ids
kamiks11387913_kamiks
keramics1644823keramics
kraits104912203kra_its
lameds94812033_lameds
lamias85020613_lamias
maids86327143_ma_ids
mamies104626243_mamies
marauds1037553mara_uds
mermaids1355753mermaids
mids76541783___mids
navaids1134803nava_ids
orchids1377213orchids
ozalids1794063ozalids
paramos113213513param_os
paranoids1248913paranoids
parotids112610413parotids
peracids13310073peracids
phasmids16195183phasmids
plaids94312443pla_ids
plasmids13236553plasmids
prams96125513pram__s
praxis154012253praxi_s
prebids12399883prebids
premeds12389583premeds
premies113823063premies
premiss113513813premiss
pyralids1445813pyralids
pyramid1547513pyramid_
qaids156116313_qa_ids
rabid84520783_rabid_
rabies85226023_rabies
radios74018673_radios
radius73914873_radius
rads56046603_ra__ds
ragis66325603_ragi_s
raias54631123_ra_ias
raid55243073_ra_id_
rails55937403_ra_ils
rains55140233_ra_ins
rais45252623_ra_i_s
rakis95323443_raki_s
ramada9310183_ramada
ramadas1039303_ramadas
ramees84620893_ramees
ramets83517393_ramets
rami66034093_rami__
ramie75027823_rami_e
ramify14268753_ramify
ramous8417113_ramous
ramps96224633_ram_ps
ramrods1036583_ramrods
rams65950773_ram__s
ramtils938413_ramtils
ramus76418283_ram_us
rands65930453_ra_nds
ranid66429333_ranid_
ranis55235833_rani_s
rapid86422033_rapid_
ratios64922673_ratios
ravins94622563_ravins
rawins95617623_rawins
rebids94015533_rebids
reminds104614793_reminds
remiss84216353_remiss
remits85622943_remits
resids74219153_resids
rids56539543_r__ids
saids65328853_sa_ids
salamis9313513salami_s
sarcoids1137803sarcoids
sayids104310973_sayids
sialids839723sialids
sparids103512123sparids
swamies123712063swamies
swamis114212293swami_s
tabanids1144963tabanids
tamis76728733_tami_s
taramas9612703taram_as
tatamis939723tatami_s
tragics10338083tragics
traiks104013713tra_iks
trails64622513tra_ils
trains64725343tra_ins
traits65121983tra_its
tramels93812493tramels
tramps105114453tram_ps
trams75327673tram__s
triacids1146723triacids
umamis1038273umami_s
uracils939373uracils
uraemias1046043uraemias
uranias72113813uranias
uranide82212093uranide
uranides92211283uranides
uraris63817273urari_s
uremias9249503uremias
ursids737823ur_sids
zamias174212923_zamias

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 Limit1340272967.56317721.4
3Display Results2962960.0933182.8
 (SQL Overall)1786912967.81222873.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.