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

106 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
cyclops163538(None) 
cyclopes1746261cyclopes
cyclos1338071cyclo_s
clops95924852__clops
collops112611752collops
cyclers1435872cyclers
cycles1339302cycl_es
cyclins1438302cyclins
cyclo1237702cyclo__
cycloid1539282cycloid
cycloids1647042cycloids
cyclone1437242cyclone
cyclones1537482cyclones
cycloses1538182cycloses
cyclosis1547472cyclosis
beclogs1237073beclogs
cacaos104616183cacao_s
cachous14312583cachous
callous93516603callous
calos74431903c_alo_s
carhops14329703carhops
cellos84517803cello_s
celoms10412123c_eloms
cholos114716853cholo_s
chops125019873__chops
chylous15107273chylous
claps95626183__claps
clips96018303__clips
clods85320863__clods
clogs85519553__clogs
clomps125212233__clomps
clons75228133__clons
clop86929893__clop_
clots75627643__clots
cloys104916943__cloys
coccous1039003coccous
cockups1735223cockups
cocoas104915743coc_oas
cocoons11310563cocoons
cocos95624693coc_o_s
coeloms1139063coeloms
collop107312313collop_
cologs96517353c_ologs
colons86028683c_olons
colors86622373c_olors
coops96229643__coops
coplots11511593coplots
cops86751373__c_ops
cowflops1842983cowflops
cowplops1743173cowplops
crops96125233__crops
cuckoos1585123cuckoos
cycads14476213cyc_ads
cycas126513823cyc__as
cycases1437533cycases
cyclase1436613cyclase
cyclases1537133cyclases
cycle1239523cycl__e
cycled1436543cycl_ed
cycler1335913cycl_er
cyclery1763493cyclery
cyclic1238033cycl_ic
cyclin1339273cycl_in
cycling1537213cycling
cyclings1635373cyclings
cyclist1438853cyclist
cyclists1545713cyclists
cyclitols1642473cyclitols
cyclize2345403cyclize
cyclizes2445523cyclizes
cyclonal1544603cyclonal
cyclonic1446973cyclonic
cyclopean1854013cyclopean
cymlins1436693cymlins
cymols1377193cy_mols
cymous1388403cy_mous
cytons111710183cy_tons
dollops10287963dollops
escalops1244673escalops
flops105920143__flops
gallops103211653gallops
galops94712623_galops
glops85619553__glops
hydrops16197413hydrops
hyssops1543123hyssops
inclips1135963inclips
jalops15329593_jalops
lollops9227443lollops
lops66043353___lops
nylons9267973ny_lons
orlops847303_orlops
plops95920333__plops
pylons113011243py_lons
scallops12297393scallops
scollops12235703scollops
scoops105414363_scoops
scops95820193_sc_ops
slops75026013__slops
sysops1136013sy_sops
tycoons1235173tycoons
unclips1136433unclips
unclogs1036803unclogs
wallops123410413wallops
xylols1634173xy_lols
yclept1336013_yclept
yelps105712993_yel_ps

Search took 7 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.423422437.4
2DLD Change Limit1340271065.61023890.7
3Display Results1061060.0303533.3
 (SQL Overall)1786911066.06329472.4
 
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.