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

175 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
cygnets133381(None) 
cygnet1237891cygnet_
carnets93918402carnets
cornets94820572cornets
magnets10311142magnets
signets83311502signets
agents74816293_agents
aglets73915683_aglets
aiglets84012913aiglets
aigrets82810533aigrets
argents84014853argents
baguets1037483baguets
bannets94013843bannets
bayonets13135583bayonets
begets96215523beg_ets
beignets11155373beignets
bennets94712163bennets
bigness1038193bigness
bonnets94812803bonnets
brunets9419553brunets
burnets93813263burnets
bygones1335913bygone_s
cabinets1238283cabinets
cablets114216343cablets
cachets145014263cachets
cadets96316503c_adets
cagers95624183cag_ers
cages85936013cag_e_s
cagiest102916433cagiest
caginess11310303caginess
callets93821703callets
camlets114314623camlets
caners84629193c_aners
canes75350373c_ane_s
cannels93413363cannels
canners93822663canners
cants77036943c_an_ts
caplets114914523caplets
carets85330773c_arets
carnet84732873carnet_
carneys124310543carneys
carpets113915333carpets
caskets133910173caskets
cements112714223cements
cents74730333c_en_ts
cermets1139713cermets
chalets122813473chalets
chants115020393chan_ts
chines115029173chine_s
chints115117833chin_ts
cigarets1145463cigarets
cines75239683c_ine_s
civets115212543c_ivets
clarets94111103clarets
clients938093clients
clines84926043cline_s
cloners94514823cloners
clones84526563clone_s
closets94611603closets
coagents1138443coagents
cobnuts1135343cobnuts
cogent9321003cogent_
cognacs1256043cognacs
cognate10312193cognate
cognates11311573cognates
coignes103912153coigne_s
coiners93620753coiners
collets93517903collets
comets105823583c_omets
cones76457423c_one_s
coneys115218423c_oneys
congees103517923congees
congers104223233congers
conges94928173conge_s
congest104618773congest
congests113510383congests
connects123010563connects
conners94023113conners
contes84432913c_ontes
coquets18399893coquets
corneas94716993corneas
cornels94716663cornels
corners94723313corners
cornet84436733cornet_
coronets103814363coronets
corsets94819803corsets
corvets124715023corvets
cosets85824403c_osets
cossets95014283cossets
counts84618273coun_ts
covets114819643c_ovets
coyness1277323coyness
cranes84330753crane_s
crenels93711013crenels
crones84729243crone_s
crownets13407673crownets
cruets85314953c_ruets
crusets93811043crusets
culets85518513c_ulets
cullets94015613cullets
cunners93913463cunners
cunts76125123c_un_ts
curets84922343c_urets
curvets12399913curvets
cutlets94113653cutlets
cyanate12259703cyanate
cyanates13238423cyanates
cyanids13297933cyanids
cyanins122910013cyanins
cyanite122710763cyanite
cyanites132610153cyanites
cyans105714813cyan__s
cyclers1435873cyclers
cycles1339303cycle_s
cyders12398833cy_ders
cyeses11510123cyese_s
cymenes1477413cymenes
cymes1210118923cy_me_s
cynics13377363cy_nics
cyphers17316753cyphers
cypres1338523cypre_s
cypress1434653cypress
cysts105912773cy__sts
dipnets10109033dipnets
dragnets10136563dragnets
dynels10536813dy_nels
dynes95917583dy_ne_s
eaglets84111663eaglets
egrets72712243_egrets
eyelets1057523eyelets
gannets83811443gannets
garnets84115403garnets
genets75716663_genets
gents65729613__gents
gets55442483__g_ets
giglets93211553giglets
gnats65217713__gnats
goglets9379783goglets
guglets9369693guglets
gurnets84010793gurnets
hoggets12498323hoggets
hognuts1134183hognuts
hornets104113553hornets
jennets14517633jennets
linnets739833linnets
loggets9378913loggets
lunets66914763_lunets
magnet9320663magnet_
magneto1046743magneto
magnetos1146263magnetos
nets45941533___nets
nonets64118703_nonets
nuggets936383nuggets
piglets103311793piglets
pignuts1035613pignuts
planets93914083planets
punnets9409263punnets
regents83416543regents
reglets83512983reglets
regrets83212923regrets
rennets75212633rennets
sennets73712583sennets
signees83510803signees
signers84714433signers
signet73621153signet_
sonnets74211993sonnets
spinets94714813spinets
subnets92512083subnets
syndets1136113syndets
telnets738373telnets
tenets65518953_tenets
tynes85920303ty_ne_s
wiglets113411423wiglets
yentes95517603_yentes
zygotes20355163zygotes

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271757.11018850.5
3Display Results1751750.0602916.7
 (SQL Overall)1786911757.32624391.3
 
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.