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

123 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
mansards114801(None) 
mansard1049311mansard_
manwards1447611manwards
canards10311202can_ards
laniards967312laniards
lanyards1266392lanyards
mallards1138322mallards
mansarded1343992mansarded
manward1349092manward_
mazards1937702ma_zards
mazzards1943942mazzards
sansars73313912sansar_s
tankards1366252tankards
tanyards1276182tanyards
absurds1035003_absurds
anears63717183_anear_s
awards107113453_a_wards
bankcards1873783bankcards
barnyards1543493barnyards
bastards113310313bastards
bayards13379683ba_yards
brassards1244063brassards
caesars9410733caesar_s
canard9314763can_ard_
dastards10278083dastards
fanfares1436773fanfares
flancards1543183flancards
gabbards1445753gabbards
guisards1043603guisards
haggards14366763haggards
halyards1576243halyards
hangars114313493hangar_s
hansas94616043hansa__s
haywards1845873haywards
hazards2037463ha_zards
innards837153_innards
inwards1138343_inwards
kantars11310033kantar_s
laggards11307053laggards
landwards1445503landwards
laniard868523laniard_
lanyard1167293lanyard_
maars74621633ma__ar_s
maenads1037373maena_ds
maestros1046163maestros
mainlands1244693mainlands
mainsails1144853mainsails
makars124612633ma_kar_s
malars85020683ma_lar_s
mallard10310273mallard_
manages103418963man_ages
mananas93414733man_anas
manas76240433man_a__s
manats84623463man_a_ts
mandalas1139443mandalas
mandamus1345523mandamus
mandarin11411023mandarin
mandarins12410393mandarins
mandates11314093mandates
mangas94122923manga__s
mangers103521263manger_s
mangolds1235193mangolds
manhoods1447243manhoods
maniacs114313063mania_cs
manias84029033mania__s
manmade1237963manma_de
mannans93611523manna_ns
mannas85019803manna__s
manners93417833manner_s
manors84420883man_or_s
manses84225513mans__es
mansions1069793mansions
mantas85725363manta__s
mantids103113623man_tids
mantrams12288963mantrams
mantraps12298063mantraps
mantras93815863man_tras
manuals9311213manua_ls
manuary1237773manuar_y
manures9313353man_ures
marauds1037553ma_rauds
marsalas1038253marsalas
masalas9312053ma_salas
masas75630413ma_sa__s
mascaras1237693mascaras
masers84623453ma_ser_s
masjids17175403ma_sjids
massacres1344693massacres
massages1159883massages
massas85116463massa__s
matsahs1236563matsa_hs
maybirds1643323maybirds
mazard1838763ma_zard_
mazzard1844463mazzard_
menads95514383men_a_ds
mensas85115863mensa__s
misadds1136303m_isadds
monads94515303mon_a_ds
monarda1046613mon_arda
monardas1145713mon_ardas
moonwards1574203moonwards
mustards11297883mustards
nards65928463__n_ards
onwards1137173_onwards
poniards1145823poniards
ransacks1445773ransacks
saggards11397493saggards
samsaras1045873samsaras
sangars83116253sangar_s
sansar63613393sansar__
sards64736183___sards
sarsars73512143sarsar_s
standards1145203standards
sunwards1236443sunwards
tabards10310383ta_bards
tanbarks1445563tanbarks
tankard1267263tankard_
tantaras8269543tantaras
tanyard1167183tanyard_
vanguards1443273vanguards
vanward1456943vanward_
vawards14457573va_wards
visards11328153_visards

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.420425454.8
2DLD Change Limit1461621237.03320782.3
3Display Results1231230.0602050.0
 (SQL Overall)1786911237.51323784.2
 
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.