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

78 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
adoptions124578(None) 
adaptions1245221adaptions
adoption1146081adoption_
abortions1147782abortions
adaption1145642adaption_
additions1186332additions
ademptions1543382ademptions
adnations1039752adnations
adopting1237452adopti_ng
adoptionism1653392adoptionism
adoptionist1454962adoptionist
adorations11310232adorations
adsorptions1444162adsorptions
amotions1069842amo_tions
cooptions13107762cooptions
options93810602__options
abductions15125383abductions
ablations11311513ablations
ablutions1146603ablutions
abolitions1246653abolitions
abortion1048103abortion_
abruptions1443843abruptions
absorptions1544593absorptions
actions94218513a__ctions
adaptations1464573adaptations
adapting1236643adapti_ng
adaptors1145263adapt_ors
addictions14125363addictions
addition1096893addition_
adductions14104953adductions
ademption1443493ademption_
adhesions1343793adhesions
admonitions1444243admonitions
adnation9310783adnation_
adoptees1145123adopt_ees
adopters1136693adopt_ers
adoptianism1652553adoptianism
adoptionisms1753353adoptionisms
adoptionists1553923adoptionists
adoptive1445503adopti_ve
adopts998083adopt___s
adoration10311313adoration_
adsorption1344273adsorption_
adulations11310123adulations
advections1645553advections
advocations1755413advocations
aerations9317903aerations
agnations10310033agnations
alations82518893a_lations
ambitions1346343ambitions
amotion9710473amo_tion_
apportions1446283apportions
auctions104012143a_uctions
auditions1078753auditions
aviations12311553aviations
avocations15168683avocations
captions123813223_captions
coitions10312853_coitions
cooption1288343cooption_
dictions111812673_dictions
donations101112353_donations
dotations101411633_dotations
editions9310403ed_itions
eductions1268773eductions
emotions10610283emo_tions
eruptions1146763eruptions
gumptions1443773gumptions
ideations1039903ideations
iodations1039113iodations
lotions74614763_lo_tions
motions94215003_mo_tions
notions74014483_no_tions
option83612713__option_
portions10514413_portions
potions93417423_po_tions
preoptions1447643preoptions
radiations11311923radiations
sorptions1137123sorptions

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.436409841.7
2DLD Change Limit148641787.15620771.5
3Display Results78780.0302600.0
 (SQL Overall)178691787.62223444.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.