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

56 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
marauders124426(None) 
marauder1144551marauder_
malanders1237022malanders
marauded1244332maraude_d
marauds1037552maraud__s
paraders113113112para_ders
abraders1137343abra_ders
arguers8489033_argu_ers
arousers84810983_arousers
awarders1245073_awarders
braiders114110573_braiders
branders114313093_branders
carders104820353car__ders
carousers1156743carousers
defrauders1541993defrauders
graders94716013_gra_ders
harassers1246203harassers
hazarders2243023hazarders
larders83516943lar__ders
larrupers1142523larrupers
lauders84012893__lauders
madders113513213m__adders
managers112911003mana_gers
maneuvers1443193maneuvers
manurers1037593ma_nurers
maraud938943maraud___
marauding1344983marauding
maravedis1542963maravedis
marblers12319233mar_blers
marchers153710813mar_chers
mariners103113863mar_iners
markers133516103mar__kers
marketers1545983marketers
marquees19206243marqu_ees
marques182610863marqu_e_s
marquess19204953marqu_ess
marrers93414313mar__rers
marriers103312473mar_riers
masquers19195703masqu_ers
matadors1156983mata_dors
maturers1037383ma_turers
maulers94213303m__aulers
maunders11348343ma_unders
meanders1168833m_eanders
miradors1146853mira_dors
murders103311363mur__ders
murmurers1342673murmurers
parader103914863para_der_
parades104121463para_de_s
paradors113411903para_dors
raiders84615143__raiders
smaragdes1343033smaragde_s
stranders10389933stranders
traders84316953_tra_ders
warders113416813war__ders
yarders113211593yar__ders

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 Filter1786911486410.406440125.6
2DLD Change Limit148641566.59322545.3
3Display Results56560.0301866.7
 (SQL Overall)178691567.02925422.0
 
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.