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

97 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
adaption114564(None) 
adaptions1245221adaptions
adoption1146081adoption
adaptation1355222adaptation
adapting1236642adapting
adaptive1445132adaptive
adaptor1034942adapt_or
addition1096892addition
ademption1443492ademption
adnation9310782adnation
adoptions1245782adoptions
alation72920552ala_tion
caption113513692_caption
abduction14125413abduction
ablation10312433ablation
ablution1047223ablution
abortion1048103abortion
abruption1343973abruption
action84719683__action
adagio847673ada_gio_
adagios945513ada_gios
adapt81218553adapt___
adaptations1464573adaptations
adapted1135843adapt_ed
adapter1036173adapt_er
adapters1136103adapters
adaptors1145253adaptors
adapts9107813adapt__s
addiction13146013addiction
additions1186333additions
adduction13225163adduction
ademptions1543383ademptions
adhesion1244433adhesion
adnations1039753adnations
adopting1237453adopting
adoptive1445503adoptive
adoration10311313adoration
adsorption1344273adsorption
adulation10311013adulation
advection1545553advection
aeration8319933aeration
agnation9311723agnation
alations82518893ala_tions
ambition1246563ambition
amotion9710473a_motion
andantino1044893andantino
auction93412933a_uction
audition979173audition
aviation11312743aviation
bastion9312473_bastion
captions123813223_captions
cation83925503_ca_tion
caudation1269993cauda_tion
caution93013523_caution
coaction12310773coaction
cooption1288343cooption
dalton7311273_dalt_on
diction102313053_diction
edition8310853ed_ition
eduction1169053eduction
elation73620453ela_tion
enation73419233ena_tion
eruption1047043eruption
exaction1738953exaction
faction122613333_faction
fraction1359483fraction
gradation11107713grada_tion
gumption1343983gumption
halation11313853hala_tion
ideation9310493ideation
inaction1039623inaction
iodation9310383ioda_tion
kation104315683_ka_tion
laudation1088133lauda_tion
lavation1139973lava_tion
laxation1538423laxa_tion
natation81513933nata_tion
nation64322803_na_tion
nidation9410583nida_tion
option83612713__option
oration71617713ora_tion
ovation101510023ova_tion
paction112713963_paction
palpation1339073palpation
pupation1269503pupation
radiation10313393radiation
ration64226013_ra_tion
reaction10612603reaction
redaction1259663redaction
sedation9312453seda_tion
sorption1037513sorption
station72717243sta_tion
sudation9310803suda_tion
taction93213023_taction
taxation1537993taxa_tion
traction10412683traction
vacation131911893vaca_tion

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.1561145455.1
2DLD Change Limit146162977.33019940.2
3Display Results97970.0303233.3
 (SQL Overall)178691977.51623774.7
 
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.