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 “mandators” 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
mandators124787(None) 
mandator1148181mandator_
mandatory1545251mandatory
emanators1147032eman_ators
emendators1344202emendators
laudators1045892laudators
mandatary1543242mandatary
mandates11314092mandat_es
mandatories1454962mandatories
abators94413083_a_bators
ablators1069873_ablators
adaptors1145253_a_daptors
aerators8315613_aerators
amendatory1653113amendatory
animators111210423_animators
auditors947613_auditors
aviators11169903_aviators
bandagers1335883bandagers
banditos11347633bandito_s
barrators1148393barrators
candors104216763cand__ors
cantors94620753can__tors
caveators1497263caveators
donators9310403don_ators
emanator1047293eman_ator_
emendator1244243emendator_
inundators11114383inundators
janitors1536853jan_itors
laudator945883laudator_
laudatory1344603laudatory
macerators14167483macerators
madtoms1236923ma_d_toms
managers112911003man_agers
manatees10310423man_atees
manatoid1148823man_atoid
manats84623463man_at__s
mandalas1139443manda_las
mandamus1345523manda_mus
mandarins12410393mandarins
mandataries1453823mandataries
mandate10315573mandat__e
mandated12310293mandat_ed
mandating1339773mandating
mandatorily1752343mandatorily
mandragora1451773mandragora
mandragoras1551503mandragoras
manganous1245763manganous
manitos9314053man_ito_s
manitous1039173man_itous
mannitols1143433mannitols
manors84420883man___ors
marcatos1249163marcato_s
matadors1156983ma_tadors
mediators1248923mediators
mentors9314993men__tors
migrators1247543migrators
minatory1338553min_atory
monitors10310823mon_itors
narrators947863narrators
palpators1346793palpators
pandoors11258983pand_oors
predators12310083predators
radiators1049323radiators
sandstorm1254003sandstorm
sandstorms1343073sandstorms
senators8312953sen_ators
tandoors9258053tand_oors
valuators1286463valuators

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.420425454.8
2DLD Change Limit148641687.31320325.6
3Display Results68680.0302266.7
 (SQL Overall)178691687.76323018.3
 
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.