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

270 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
martians10311161(None) 
martian93514681martian_
martins93322061marti_ns
artisans888522_artisans
bartisans1165552bartisans
bartizans2053702bartizans
magians10310752ma_gians
margins103815192margi_ns
marinas93519382mar_inas
marlins93420472marli_ns
martens93714952mart_ens
martial92415412martia_l
martin84122522marti_n_
marting103325012marti_ng
martini93613872marti_ni
martinis103311612martinis
marzipans2242642marzipans
matins84527782ma_ti_ns
mattins93316142matti_ns
parians93519732par_ians
partans94418282part_ans
partials101911952partials
partisans1167482partisans
partizans2055242partizans
tartans72615822tart_ans
tertians839102tertians
actins86321103_acti_ns
actions94218513_actions
amotions1069843amotions
amritas939093amrita_s
antiars7314623_antiars
arias55438023_ar_ia_s
artisan759463_artisan_
artists74215593_artists
atmans84413963_a_tmans
attains7310983_attains
avians93711563_a_vians
banians9312033ba_nians
barbicans1544483barbicans
barchans1588683barchans
bargains1178643bargains
bartisan1056163bartisan_
bartizan1954413bartizan_
bastions10411693bastions
caftans12179443caft_ans
cantinas102713773cantinas
captains121810573captains
captans111612053capt_ans
captions123813223captions
caravans1338623caravans
cardiacs1376913cardiacs
cardias10715113cardia_s
cardigans1345153cardigans
carinas93622403car_inas
caritas93316953carita_s
carlins93921913carli_ns
carotins102315583caroti_ns
carrions10312453carrions
carting104228283carti_ng
cartons94122473cart_ons
cartoons104012803cartoons
cations94524143ca_tions
cautions103313183cautions
cortinas102212443cortinas
cortins92421333corti_ns
curtains10259703curtains
darshans1286543darshans
darting94020663darti_ng
durians839573dur_ians
factions133013063factions
farinas103215233far_inas
farting114120753farti_ng
fustians1146403fustians
gentians937563gentians
gratins84119183grati_ns
guardians1143913guardians
habitans1346623habitans
hamartias14115363hamartia_s
hardpans1436453hardpans
hariana10310243har_iana
harianas1139163har_ianas
harijans1845723harijans
harmins123716723harmi_ns
harpins123615703harpi_ns
harridans13154563harridans
hartals10313023hart_als
jarinas143712183jar_inas
kaftans14185353kaft_ans
kalians11310183ka_lians
karting123716063karti_ng
kartings13418523kartings
kations114013663ka_tions
lariats7615053lar_iats
larrigans1044013larrigans
latinas74416463la_tinas
latrias71913213latria_s
lattins74115483latti_ns
macrurans1343533macrurans
maffias15327283maffia_s
mafias113913573ma_fia_s
maftirs1236043mafti_rs
magian9312833ma_gian_
magicians1444573magicians
mains75635113ma__i_ns
maintains1167103maintains
maligns1038133ma_ligns
malkins133311803malki_ns
malthas1237913maltha_s
malting103219083malti_ng
maniacs114313063ma_niacs
manias84029033ma_nia_s
mannans93611523ma_nnans
mansions1069793mansions
mantas85725363mant_a_s
manteaus1036383manteaus
mantids103113623manti_ds
mantis83926033manti__s
mantises10317923mantises
mantrams12288963mantrams
mantraps12298063mantraps
mantras93815863mantra_s
mantuas93410993mantua_s
maracas11313773maraca_s
maras75443293mar__a_s
marathons1446413marathons
margays1337493mar_gays
margin94016843margi_n_
marginal1137603marginal
marginals1246003marginals
maria75032883mar_ia__
marina84623413mar_i_na
marine84230403mar_i_ne
marines93928013mar_ines
marital92314183marita_l
markas124717003mar_ka_s
marking144020133marki_ng
markings153410243markings
markkas12356083markka_s
marlin84220903marli_n_
marline93320953marli_ne
marlines103818713marlines
marling103322763marli_ng
marlings113713493marlings
marlites103415263marlites
marmites122212793marmites
marocains1346353marocains
maroons92615553mar_oons
marrams11310123mar_rams
marrano939423mar_rano
marranos1038423mar_ranos
marriage1147253marriage
marriages1247383marriages
marrieds11288073marrieds
marriers103312473marriers
marries93825283marri_es
marring103319553marri_ng
marrons93216973mar_rons
marshals1337783marshals
martagons1245123martagons
marten84518263mart_en_
martially1448183martially
martinet10319643martinet
martinets1138883martinets
martingals1343313martingals
martlets103310483martlets
marts77442233mart___s
martyrs1234893mart_yrs
maryjane2043043maryjane
maryjanes2142993maryjanes
marzipan2142693marzipan_
mastics112614783masti_cs
mastiffs1644233mastiffs
masting104325823masti_ng
mastitis1039103mastitis
mastixes1738253mastixes
matin75132853ma_ti_n_
matinal9312603ma_tinal
mating94832913ma_ti_ng
matings104516213ma_tings
matrass939403ma_trass
matrices12312083matrices
matrixes1738063matrixes
matrons93517633ma_trons
matsahs1236563ma_tsahs
mattin84416633matti_n_
matting103620143matti_ng
mattings11369673mattings
mattrass1045863mattrass
matzahs2134483ma_tzahs
matzas1749703ma_tza_s
mavins115119183ma_vi_ns
mayvins1535323mayvi_ns
medians103214213m_edians
mentions10312893mentions
meridians1245543meridians
merlins93015813merli_ns
mirins83918903mir_i_ns
morgans10310123mor_gans
morions94014643mor_ions
morrions1077673morrions
mortals93914003mort_als
mortars93411523mort_ars
mortices12711563mortices
morticians1445703morticians
mortises10713613mortises
mortmains1344493mortmains
motions94215003m_otions
muntins92715133munti_ns
mureins9310733murei_ns
murrains1036853murrains
myriads1334353myr_iads
nations74720563na_tions
orations81515803orations
pactions122613503pactions
paphians1545593paphians
pariahs123812343par_iahs
parian83223963par_ian_
partan83820563part_an_
partial92616263partia_l
partiers103514243partiers
parties93230863parti_es
parting103527383parti_ng
partings113513733partings
partisan1058423partisan_
partitas10310253partitas
partizan1955643partizan_
partons94620513part_ons
pastinas103712153pastinas
patinas96318523pa_tinas
patins87528783pa_ti_ns
pertains102113423pertains
portions10514413portions
puritans1037633puritans
quartans1736283quart_ans
radians83013823ra_dians
ratans63819373ra_t_ans
rations74123433ra_tions
rattans73411953ra_ttans
salpians1036763salpians
saltpans1034813saltpans
samaritans1242933samaritans
sarans64224433sar__ans
sarcinas1039273sarcinas
sarins63932623sar_i_ns
satins64930483sa_ti_ns
saurians837763saurians
smartass1044273smart_ass
smartens10286663smart_ens
smarties10312873smarti_es
smarting113212453smarti_ng
spartinas1135793spartinas
tactions102912423tactions
tarpans92513533tar_pans
tarsias74013373tarsia_s
tartan64217513tart_an_
tartana73010193tart_ana
tartanas8258893tart_anas
tartars73313403tart_ars
tarting84222653tarti_ng
tarzans16329923tar_zans
tertials8510073tertials
tertian7511193tertian_
titians72710453_titians
variant10316803var_iant
variants1139203var_iants
varias95019903var_ia_s
wartimes1336963wartimes
xanthans1845693xanthans
yautias1046333yautia_s
zaptiahs2242063zaptiahs

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.406440125.6
2DLD Change Limit1461622706.65621959.4
3Display Results2702700.1102454.5
 (SQL Overall)1786912707.17224915.1
 
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.