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

73 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
matadors115698(None) 
matador1066251matador_
malodors1144972malodors
miradors1146852miradors
paradors113411902paradors
abators94413083_abators
amadous1038503_amadous
ardors74416873_a_rdors
bahadurs1442553bahadurs
candors104216763ca_ndors
cataloes10311653cataloes
catalogs1148033catalogs
catalos9414163catalo_s
chadors1338753_chadors
citators10310253citators
emanators1147033emanators
gators74115833gat__ors
imitators1147013imitators
labradors1243793labradors
maars74621633ma_a__rs
macacos1338083macaco_s
macadams1545093macadams
machzors2444113machzors
madders113513213ma_dders
magalogs1245253magalogs
mahzors2135123ma_hzors
majors154511093m__ajors
makars124612633maka__rs
maladies11311933maladies
malanders1237023malanders
malars85020683mala__rs
malodor1044563malodor_
managers112911003managers
mandators1247873mandators
manors84420883m__anors
marabous1249063marabous
marauders1244263marauders
markhors1745393markhors
martagons1245123martagons
mastodons1244123mastodons
matchers153012433matchers
matelots1047533matelots
maters85032393mat__ers
matrons93517633mat_rons
matters94421753mat_ters
maturers1037373maturers
matzohs2134373mat_zohs
matzoons19105083matzoons
matzos1749263mat_zo_s
maunders11348343maunders
mayors115714193m__ayors
meadows1337333m_eadows
metamers1249623metamers
metaphors1645683metaphors
meteors94610013met_eors
methadons1544423methadons
mikados1444683mikado_s
mirador1046503mirador_
motors84616603mot__ors
natatory1146603natatory
papadoms1575923papadoms
paraders113113113paraders
parador103311413parador_
paradores12259653paradores
parados103816053parado_s
patamars1246843patamars
picadors1345853picadors
rotators8310203rotators
stators73915583_stators
tabors84517113__tabors
tatars64619793tata__rs
vanadous1246033vanadous
vavasors14153653vavasors

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.423422437.4
2DLD Change Limit146162737.25020160.3
3Display Results73730.0302433.3
 (SQL Overall)178691737.70323197.6
 
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.