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

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
educationalists1892721educationalists_
educationalist1763282educationalist__
educationists1654343education__ists_
educationist1555264education__ist__
vocationalists1964084_vocationalists_
educational1444875educational_____
educationally1963315educational___ly
educationeses1661545education__eses_
emotionalists15155825e__motionalists_
functionalists1964365_functionalists_
irrationalists1464735_irrationalists_
nationalists122010335___nationalists_
operationalists1763885operationalists_
rationalists121910065___rationalists_
reductionists1654665reduc_tion__ists_
sensationalists15244615sensationalists_
vocationalisms2163775_vocationalisms_
vocationalist1855105_vocationalist__
atonalists1048496____at_onalists_
denationalizes24115526_denationalizes_
deviationists17104746deviation__ists_
educationese1551966education____ese
educations1339236education_____s_
elocutionists1554316elocution__ists_
emotionalisms17145326e__motionalisms_
emotionalist14146876e__motionalist__
emotionalistic1862836e__motionalistic
exceptionalisms28162536exceptionalisms_
factionalisms20106366_fac_tionalisms_
fictionalises1855846_fic_tionalises_
functionalisms2163986_functionalisms_
functionalist1865266_functionalist__
functionalistic2272296_functionalistic
irrationalisms1664686_irrationalisms_
irrationalist1355816_irrationalist__
irrationalistic1772716_irrationalistic
nationalises122910366___nationalises_
nationalisms14259796___nationalisms_
nationalist111412166___nationalist__
nationalistic1595556___nationalistic
operationalisms1963716operationalisms_
operationalist1664906operationalist__
rationalises122010376___rationalises_
rationalisms14219496___rationalisms_
rationalist111812126___rationalist__
rationalistic15125456___rationalistic
reductionisms1853806reduc_tion__isms_
reductionist1556006reduc_tion__ist__
reductionistic1962126reduc_tion__istic
sectionalisms1756526_sec_tionalisms_
sensationalises15234686sensationalises_
sensationalisms17274356sensationalisms_
sensationalist14235296sensationalist__
traditionalists16133296traditionalists_
vacationists1754586_vacation__ists_
vocationalism2054416_vocationali__sm

Search took 6 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 Filter178691658740.313570897.8
2DLD Change Limit65874564.76313830.4
3Display Results56560.0461217.4
 (SQL Overall)178691565.12234887.0
 
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.