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

142 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
cotingas1131632(None) 
cotinga10348021cotinga_
coatings113811842coating_s
comings124013532coming_s
congas94417032co__ngas
copings124111842coping_s
cortinas102212452cortin_as
coting94629252coting__
covings134511242coving_s
actings104512463acting_s
actinias101810853actinias
anhingas12104333anhingas
antings85015583anting_s
boatings113710113boating_s
bodings113711653boding_s
boings96416873bo_ing_s
borings103614243boring_s
bowings133612003bowing_s
boxings17429163boxing_s
bubingas1352803bubingas
cantinas102713783cantin_as
carinas93622423carin_as
casings104013513casing_s
castings113614053casting_s
catenas9313113caten_as
catlings113712043catling_s
cavings134712543caving_s
chinas115119403c_hin_as
citing94220183citing__
clings95716213c_ling_s
clonings11307433cloning_s
closings11277673closing_s
clothings15264433clothing_s
coamings13349293coaming_s
coastings12357863coasting_s
coating103525313coating__
cobias104014993cobi__as
cocineras1344963cocineras
codeinas11338023codein_as
coding104024793coding__
codlings123110103codling_s
coignes103912153co_ignes
coigns94410063co_i_gns
coinage10310553co_inage
coinages11310803co_inages
coiners93620753co_iners
coins75834553co_in__s
coking134523883coking__
colinear1045913colinear
colins85229043colin__s
combings15348323combing_s
coming114225453coming__
comingle1336053comingle
comingles1444723comingles
conga85419873co__nga_
conges94928173co__nges
congos94219883co__ngos
conines93827793conin_es
coning94331833coning__
conins84327233conin__s
continua1047653continua_
continual1147143continual
continues11310993continues
continuos1147003continuos
cooing94024923cooing__
cooingly1436353cooingly
cookings15358603cooking_s
coping113927663coping__
coquinas1944783coquin_as
corbinas12229403corbin_as
cordings123011363cording_s
coring94433963coring__
corneas94717003co_rneas
coronas93916913coron_as
cortina91915973cortin_a_
cortins92421333cortin__s
corvinas13238023corvin_as
cosigns1047513cosi_gns
cosines94122673cosin_es
cosiness103214283cosiness
costing104323023costing__
cotans81317923cotan__s
cotidal1038463coti_dal
cotinine10311493cotinine
cotinines11410073cotinines
cottages113310493cottages
cottas84615573cot__tas
coving124321523coving__
covins114618063covin__s
cowing124526323cowing__
cowlings14359783cowling_s
coxing164218863coxing__
coying124021483coying__
coziness19319823coziness
cringes103215503c_ringes
cutins83919983cutin__s
cuttings11277613cutting_s
doings84913183do_ing_s
dongas84914613do__ngas
dopings11408783doping_s
doting84821913doting__
dotingly1337343dotingly
eatings84616443eating_s
fontinas1136853fontin_as
footings12248833footing_s
foxings18446963foxing_s
gatings95212823gating_s
goings84911523go_ing_s
gringas938043_gringas
jottings16275193jotting_s
latinas74416463latin_as
lingas75116573__lingas
losings82810623losing_s
lowings113710073lowing_s
lutings83311053luting_s
matings104516213mating_s
mowings13328483mowing_s
nosings8349593nosing_s
nothings12266683nothing_s
noting74120153noting__
olingos846013_olingos
outings84014753outing_s
patinas96318533patin_as
postings112912303posting_s
ratings84217413rating_s
retinas74819353retin_as
rotundas943573rotundas
rovings11439493roving_s
rowings113710363rowing_s
scotias939753scoti__as
scoutings12306143scouting_s
seringas9339003seringas
sorings83817253soring_s
stingos8459453_stingos
stings76220183_sting_s
syringas12285953syringas
tineas64616483__tineas
tinges74722343__tinges
tings65329213__ting_s
tongas74315533__tongas
toting74123793toting__
voting103916033voting__

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.406440125.6
2DLD Change Limit1461621427.37619815.9
3Display Results1421420.0463087.0
 (SQL Overall)1786911427.82822827.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.