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

66 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
cyclosis154747(None) 
cycloses1538181cycloses
cyanosis1346272cyanosis
cyclases1537132cyclases
cyclists1545712cyclists
cycloid1539282cyclo_id
cycloids1647042cycloids
cyclones1537482cyclones
cyclonic1446972cyclonic
cyclopes1746262cyclopes
cyclops1635382cyclo_ps
cyclos1338072cyclo__s
mycosis1437762myc_osis
pycnosis1554732pycnosis
sycosis1238812syc_osis
acyclovir1951603acyclovir
acyclovirs2051483acyclovirs
calloses10313393calloses
celosia939463c_elosia
celosias1048903c_elosias
closes85425593__closes
colossi935673c_olossi
coniosis1048133coniosis
cyanoses1337423cyanoses
cycases1437533cyc_ases
cycasin1445903cyc_asin
cycasins1545283cyc_asins
cyclase1436613cyclas_e
cycleries1647033cycleries
cyclers1435873cycl_ers
cycles1339303cycl__es
cyclic1238033cycl__ic
cyclin1339273cycl__in
cyclings1635373cyclings
cyclins1438303cycl_ins
cyclist1438853cyclis_t
cyclizes2445523cyclizes
cyclo1237703cyclo___
cyclonal1544603cyclonal
cyclone1437243cyclo_ne
cyclonite1645453cyclonite
cyclonites1744903cyclonites
cyesis1148573cy__esis
cytolysis1744833cytolysis
diplosis11128413diplosis
encloses10911053encloses
haplosis1347093haplosis
hypnosis1646533hypnosis
incloses101610533incloses
kyphosis2045173kyphosis
mycoses1437733myc_oses
myosis114012563my__osis
necrosis1048883necrosis
psilosis1045123psilosis
psychosis1946793psychosis
pycnoses1554973pycnoses
pyknosis1753643pyknosis
pyosis114012123py__osis
pyrosis12411653py_rosis
sycoses1249133syc_oses
tylosin1046903ty_losin
tylosins1145723ty_losins
uncloses10910943uncloses
xyloses1746843xy_loses
zygosis20405953zy_gosis
zymosis21487493zy_mosis

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.1701051123.5
2DLD Change Limit146162667.73618893.7
3Display Results66660.0302200.0
 (SQL Overall)178691667.93622516.5
 
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.