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

115 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
manteaus103638(None) 
manteau937861manteau_
manteaux1742881manteaux
bandeaus1146502bandeaus
gateaus866322ga_teaus
mantas85725362mant_a_s
mantels94515042mante_ls
mantes84430782mante__s
mantrams12288962mantrams
mantraps12298062mantraps
mantras93815862mantra_s
mantuas93410992mantua_s
anears63717183_an_ears
angelus8418463_angelus
anneals7449943_anneals
antas55432033_ant_a_s
antbears1044963_antbears
antes56334323_ante__s
antiars7314623_antiars
bandeau1038523bandeau_
bandeaux1843293bandeaux
bantams1149063bant_ams
bantengs1134593bantengs
banters94623113bante_rs
bateau8810563ba_teau_
bateaux1693883ba_teaux
batteau936343batteau_
batteaux1742503batteaux
cantals93919573cant_als
canteens1038573canteens
canters94827723cante_rs
canthus1248703cant_hus
cantraps12319113cantraps
cantus85117763cant__us
chateaus1345983chateaus
gateau778103ga_teau_
gateaux1573123ga_teaux
kantars11310033kant_ars
kanteles1238123kanteles
lacteals1095663lacteals
lacteous1046773lacteous
landaus8310343lan_daus
lanterns838303lanterns
malleus92911313malle_us
malteds10377603malte_ds
malthas1237913maltha_s
maltreats1145223maltreats
mananas93414733manana_s
manas76240423man__a_s
manatees10310423manate_es
manats84623463man__ats
mandamus1345523mandamus
maneges103612143man_eges
manes76648953man_e__s
mangas94122923man_ga_s
mangels103614493mange_ls
mangers103521263mange_rs
manges94628943mange__s
maniacs114313063man_iacs
manias84029033man_ia_s
manilas93915873manila_s
manitous1039173manitous
manitus9310923man_itus
manless93012933manle_ss
mannans93611523man_nans
mannas85019803man_na_s
manners93417833manne_rs
manses84225513manse__s
manta75629903mant_a__
mantel84317973mante__l
mantelet10613823mantelet
mantelets1176813mantelets
mantids103113623mant_ids
mantis83926033mant__is
mantises10317923mantises
mantles94820703mant_les
mantlets104611203mantlets
mantra84116093mantra__
mantram114011603mantra_m
mantrap11379823mantra_p
mantua84412023mant__ua
manuals9311213man_uals
manus75924923man___us
martens93714953marte_ns
martians103111613martians
masters94628923maste_rs
mastheads1545243mastheads
maters85032383ma_te_rs
mates75251363ma_te__s
mateys115610943ma_te_ys
matrass939393ma_trass
matsahs1236563ma_tsahs
matters94421753matte_rs
mattes85624533matte__s
mattrass1045853mattrass
matzahs2134483ma_tzahs
matzas1749703ma_tza_s
mentees93214503mente_es
minters93822463minte_rs
monteros1039443monteros
montes84226933monte__s
muntjacs1941863muntjacs
muntjaks2142003muntjaks
plateaus1035533plateaus
ranters73323643rante_rs
santeras8311053santeras
santeros8311193santeros
tableaus1054843tableaus
tantalus836373tantalus
tantras73112093tantra_s
tonneaus853913tonneaus
wanters104420093wante_rs
xanthans1845693xanthans
xanthous1846623xanthous
yantras10259003yantra_s

Search took 9 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.1561145455.1
2DLD Change Limit1461621158.67316852.5
3Display Results1151150.0462500.0
 (SQL Overall)1786911158.87520134.2
 
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.