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

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

49 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
legitimators155340(None) 
legitimator1453401legitimator_
legitimates1454022legitimat_es
legitimations1654792legitimations
estimators1247013_e_stimators
legislators1273053legi_slators
legitimacies1762413legitimacies
legitimate1354133legitimat__e
legitimated1553693legitimat_ed
legitimately1862053legitimately
legitimating1653813legitimating
legitimation1555163legitimation
legitimatize2453083legitimatize
legitimatizes2562783legitimatizes
legitimizers2461993legitimizers
levitators1345403levit__ators
litigators1145383l__itigators
negotiators1253163negoti_ators
agitators1046614_agit__ators
cogitators1345994cogit__ators
deactivators1852574deactivators
decimators1547504de__cimators
delegitimations19182444delegitimations
eliminators1344814_eliminators
estimator1147424_e_stimator_
estivators1345914_e_stivators
felicitators1752574felicitators
hesitators1385854hesit__ators
initiators10127314_initi_ators
lacrimators1553914l_acrimators
legators92811024leg____ators
legislator1162854legi_slator_
legitimacy1861974legitima__cy
legitimatized2662574legitimatized
legitimises1473464legitim_ises
legitimisms1663124legitim_isms
legitimists1463464legitim_ists
legitimizations2773324legitimizations
legitimizer2362624legitimizer_
legitimizes2363354legitim_izes
levitator1245494levit__ator_
literators1048104l__iterators
litigator1045504l__itigator_
meditators1346264medit__ators
mitigators1345374__mitigators
negotiator1153314negoti_ator_
negotiatory1552674negoti_atory
ventilators14105064ve_ntilators
vitiators1246914__viti_ators

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 Filter1786911247900.1561145455.1
2DLD Change Limit124790498.90614011.9
3Display Results49490.0331484.8
 (SQL Overall)178691499.09519647.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.