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

85 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
addition109689(None) 
addiction13146011addiction
additions1186331additions
audition979171audition
adaption1145642adaption
addictions14125362addictions
additional1244632additional
additive1345862additive
adduction13225162adduction
adnation9310782adnation
adoption1146082adoption
ambition1246562ambition
auditions1078752auditions
edition8310852_edition
sedition939332sedition
abdication1548223abdication
abduction14125413abduction
ablation10312433ablation
ablution1047223ablution
abolition1147053abolition
abortion1048103abortion
action84719683a__ction
adaptions1245223adaptions
addicting1485073addicting
addictive1644563addictive
additives1444443additives
additory1344263additory
adductions14104953adductions
ademption1443493ademption
adhesion1244433adhesion
admiration1347733admiration
admission1243733admission
admonition1344443admonition
adnations1039753adnations
adoptions1245783adoptions
adoration10311313adoration
adulation10311013adulation
advection1545553advection
aeration8319933aeration
agnation9311723agnation
alation72920553a_lation
ambitions1346343ambitions
amotion9710473a_motion
andiron848283andi_ron
attrition966963attrition
auction93412933a_uction
auditing1039033auditing
auditioned1243403auditioned
auditive1247163auditive
auditor837313audit_or
aviation11312743aviation
caudation1269993caudation
coition9314313_coition
condition12411163condition
diction102313053_diction
editions9310403_editions
eduction1169053eduction
erudition1046173erudition
fruition11106103fruition
ideation9310493ideation
ignition946533ignition
indiction1239803indiction
iodation9310383iodation
laudation1088133laudation
lenition8310083lenition
mediation12312293mediation
monition10311723monition
munition1038763munition
nidation9410583nidation
oddities1046603oddities
partition1148693partition
perdition1249013perdition
petition10711753petition
position10912193position
punition1038373punition
radiation10313393radiation
reedition1047833reedition
rendition1058933rendition
sedation9312453sedation
seditions1039013seditions
sudation9310803sudation
tradition1047583tradition
tuition738823_tuition
vendition1345693vendition
volition1179173volition

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 Filter1786911461620.1701051123.5
2DLD Change Limit146162857.31319986.6
3Display Results85850.0302833.3
 (SQL Overall)178691857.51323784.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.