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 “cooption” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

103 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
cooption128834(None) 
cooptions13107761cooptions
adoption1146082adoption
caption113513692c_aption
coaction12310772coaction
coition9314312c_oition
conation101420882conation
coopting133411312coopting
option83612712__option
sorption1037512sorption
abortion1048103abortion
adaption1145643adaption
adoptions1245783adoptions
amotion9710473amo_tion
campion133011413camp_ion
captions123813223c_aptions
cation83925503c__ation
caution93013523c_aution
chopin132712193chop_i_n
chorion12311773cho_rion
cioppino1443343cioppino
citation10314363citation
coactions1349743coactions
coalition1148703coalition
coaptation1448343coaptation
coapting133511613coapting
coercion1246573coercion
cognation12310753cognation
cognition1247013cognition
cohesion1347283cohesion
coitions10312853c_oitions
collation11313993collation
colophon1545573colop_hon
coloration12913183coloration
commotion1576983commotion
compaction1846753compaction
companion1577683companion
completion1647303completion
complin13312073compli_n
compting153013603compting
conations111318903conations
conception16410453conception
concoction1348233concoction
condition12411163condition
connation11314263connation
conniption1446273conniption
contortion1248663contortion
cooktop1544043cookt_op
coontie9311423coonti_e
coonties10513803coonties
cooperation15410023cooperation
cooping123918933coop_ing
coopt95929853coopt___
coopted123710763coopt_ed
coopts105814583coopt__s
cootie84223093coo_ti_e
cooties93725733coo_ties
copatron1246753copatron
coronation12412073coronation
corotation12410973corotation
corruption1455373corruption
cortin82423153c_orti_n
cotton8312993c_o_tton
countian1048123countian
coupon102810993coup__on
creation102816513creation
crostino1038883crostino
croton84415453cro_t_on
crouton947133crout_on
donation91513783donation
dotation91412733dotation
emotion9711303emo_tion
eruption1047043eruption
gumption1343983gumption
iodation9310383iodation
lobation102110553lobation
location102113913location
locution10227663locution
lotion65716523_lo_tion
monition10311723monition
motion85217553_mo_tion
notation81414603notation
notion64516583_no_tion
novation111710013novation
options93810603__options
oration71617713_oration
ovation101510023_ovation
portion9615493_portion
position10912193position
potation101716783potation
potion84519573_po_tion
preoption1348083preoption
rogation91612053rogation
rotation81615453rotation
scorpion1244803scorp_ion
solation8916153solation
solution889593solution
sorptions1137123sorptions
tompion11247103tomp_ion
vocation132311983vocation
volition1179173volition
volution1198603volution
zonation171410723zonation

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.436409841.7
2DLD Change Limit1461621037.34319904.9
3Display Results1031030.0502060.0
 (SQL Overall)1786911037.82922824.2
 
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.