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

82 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
federation144957(None) 
federations1548881federations
deaeration11313012deaeration
federating1548852federating
federative1746162federative
federator1346262federat_or
generation11312422generation
moderation1348652moderation
veneration13412342veneration
adoration10311313_adoration
aeration8319933__aeration
alteration10612903alteration
celebration1546463celebration
cerebration1547923cerebration
confederation1995253confederation
deaerations12311673deaerations
decoration13314423decoration
dedication14311963dedication
defecation1679803defecation
delation92318083__delation
delegation1238883delegation
denegation1249413denegation
denervation1567943denervation
desecration14410073desecration
desertion10410203deser_tion
desideration1456393desideration
desperation14510113desperation
deuteration1249103deuteration
duration9312693__duration
education12310203_education
elevation1239233_elevation
enervation1369473_enervation
execration1949833_execration
exertion15310083_exer_tion
federacies1644993federacies
federalism1644913federalism
federalist1446443federalist
federalize2345823federalize
federate12310883federat__e
federated1438423federat_ed
federates13310153federat_es
federators1446193federators
fellation1238843fe_llation
fenestration1596073fenestration
fetation11613143f__etation
figuration1445913figuration
filtration1346433filtration
generations12311423generations
hebetation1557093hebetation
hydration1646073hyd_ration
ideation9310493_ide_ation
indexation1846343indexation
induration11410613induration
iteration9515033_iteration
laceration1249573laceration
liberation1269993liberation
literation10511413literation
maceration1449613maceration
mediation12312293med_iation
medication15411173medication
meditation13410743meditation
moderations1448273moderations
numeration12137963numeration
operation11314003_operation
penetration1349893penetration
peroration12316003peroration
recreation12413613recreation
redecoration1546013redecoration
redemption1543883redemption
reiteration11412163reiteration
relegation11610023relegation
reoperation13410903reoperation
reparation12612723reparation
reservation1489143reservation
revelation13410923revelation
sedation9312453sed__ation
separation12510433separation
serration9414063se_rration
toleration1048963toleration
ulceration1247263ulceration
vegetation1448213vegetation
venerations14411313venerations

Search took 9 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 Filter1786911406030.813219792.1
2DLD Change Limit140603827.40618985.0
3Display Results82820.0302733.3
 (SQL Overall)178691828.24921662.1
 
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.