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 “macaques” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

68 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
macaques214395(None) 
macaque2044051macaque_
caciques21165372caciques
marques182610862ma_rques
masques18239362ma_sques
sacques18106862sac_ques
acarus8312193_acaru_s
accrues1135323_accrues
acquest1837173_ac_quest
baroques1934863baroques
barques18259643ba_rques
basques18248673ba_sques
cacique20205693cacique_
caiques18248793ca_iques
calques182710193ca_lques
casques18278983ca_sques
caziques28193773caziques
claques18279013_claques
facades1339033faca_des
jacales16310323jaca_les
lacquer18135153lac_quer
lacquers19125033lac_quers
lacquey21143803lac_quey
lacqueys22132693lac_queys
laliques1744833laliques
macaber1336163maca_ber
macabre1335223macabre_
macacos1338083maca_cos
macadams1545093macadams
macaws1337023maca__ws
maces97139963mac___es
maches134827233mac__hes
machetes1539633machetes
machines15312893machines
machrees1545503machrees
mackles154415753mac_kles
macles107023223mac__les
macrames1438953macrames
macules114015133mac_ules
madames12310063mada_mes
majaguas1842843majaguas
maladies11311933maladies
malaises10312333malaises
malamutes1345373malamutes
malates93522613mala_tes
manacles1239523manacles
manages103418963mana_ges
manatees10310423manatees
manque17259513ma_nque_
maquis17249483m__aquis
marauds1037553mara_uds
marque172410503ma_rque_
marquee18218583ma_rquee
marquees19206243ma_rquees
marquess19204953ma_rquess
marquis18247063ma_rquis
masque17249383ma_sque_
masquer18266463ma_squer
masquers19195703ma_squers
mosques18256923m_osques
opaques1833643_opaques
paraquet1948793paraquet
paraquets2044603paraquets
plaques18317893_plaques
racquet1838743rac_quet
racquets1944763rac_quets
sacque17107113sac_que_
vacates12312833vaca_tes

Search took 10 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.843211970.3
2DLD Change Limit146162688.89316435.6
3Display Results68680.0302266.7
 (SQL Overall)178691689.76618297.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.