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

(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
cryptographies275408(None) 
cryptographer2663742cryptograph_er
cryptographers2762912cryptographers
cryptographic2864462cryptographi_c
cryptographs2554572cryptograph__s
cartographies2156043c_artographies
cryptograph2454643cryptograph___
cryptography2854563cryptograph__y
reprographies2196093_reprographies
typographies23105663_typ_ographies
aortographies1955724_aortographies
autographies1856954__autographies
cacographies2255724c__acographies
cardiographies2353714cardiographies
chirographies2465894c_hirographies
choreographies2555274choreographies
chorographies2487434c_horographies
chronographies2574924chronographies
cosmographies2355054c_osmographies
cryotherapies2362774cryotherap_ies
cryptograms2153714cryptogra___ms
cryptorchids2592314crypto_r_chids
hydrographies2675774_hydrographies
kymographies2754484_ky_mographies
lymphographies3062644lymphographies
mythographies2754554_mythographies
orographies1767794or___ographies
orthographies2255104or_thographies
photographies2459384_photographies
physiographies2854194physiographies
pictographies2355634_pictographies
radiographies2055824_radiographies
renographies1866534_r_enographies
reprographics2395174_reprographics
stylographies2254354sty_lographies
topographies20116934_top_ographies
uranographies1954244ur_anographies
xylographies2855264_xy_lographies
angiographies2054365_angiographies
arteriographies2172745arteriographies
bibliographies2463385bibliographies
biogeographies2353355biogeographies
biographies1996495___biographies
calligraphies2153195c_alligraphies
cartographer2096115c_artograph_er
cartographers2194465c_artographers
cartographic2266755c_artographi_c
cryptogamic2362465cryptog_a_mi_c
cryptogamous2262085cryptog_a_mous
cryptogams2052695cryptog_a___ms
cryptogram2053965cryptogra____m
cryptologies2055415crypto__logies
cryptorchid2482795crypto_r_chi_d
cryptorchism26142365crypto_r_chism
cryptorchisms27131945crypto_r_chisms
cymographs2397005c_y_mograph__s
demographies2156415__demographies
discographies2284585_discographies
epigraphies1954935__ep_igraphies
ethnographies2254925_ethnographies
filmographies2454305_filmographies
flexographies2953545_flexographies
fluorographies2392875fluorographies
geographies1856615___geographies
hagiographies2354925_hagiographies
holographies2148115__holographies
iconographies2155055_iconographies
ideographies1955775__ideographies
lexicographies2962645lexicographies
lithographies2295275_lithographies
mammographies2253565_mammographies
nomographies20126605__nomographies
oceanographies2263055oceanographies
paleographies2155735_paleographies
petrographies2157145_petrographies
phlebographies2763305phlebographies
phonographies2447465_phonographies
planographies2164885_planographies
polarographies2253535polarographies
pornographies2165965_pornographies
prosopographies2262085prosopographies
prototrophies2064655pr_ototrophies
reprographer2056255_reprograph_er
reprographers2154665_reprographers
reprographic2296655_reprographi_c
scenographies21124525_scenographies
scintigraphies2261695scintigraphies
seismographies2253345seismographies
sonographies1846615__sonographies
spectrographies2562445spectrographies
stenographies19125315_stenographies
stereographies2054245stereographies
stratigraphies2062015stratigraphies
thermographies2554685thermographies
tomographies20127355__tomographies
typographed2354685_typ_ograph_ed
typographer2255345_typ_ograph_er
typographers2354075_typ_ographers
typographic2456455_typ_ographi_c
typographing2453355_typ_ographing
typographs2196485_typ_ograph__s
venographies2165675__venographies
videographies2354425_videographies
xerographies2586715__xerographies
zoogeographies301864575zoogeographies
zoographies2645805___zoographies

Search took 9 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 Filter178691950240.1261418182.5
2DLD Change Limit950241067.81312162.3
3Display Results1061060.0761394.7
 (SQL Overall)1786911068.01522294.6
 
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.