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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

73 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
cryptographers276291(None) 
cryptographer2663741cryptographer_
cryptographies2754082cryptographies
cryptographs2554572cryptograph__s
cartographers2194463c_artographers
cryptograph2454643cryptograph___
cryptographic2864463cryptograph_ic
cryptography2854563cryptograph__y
reprographers2154663_reprographers
typographers2354073_typ_ographers
cartographer2096114c_artographer_
chirographers2494694c_hirographers
choreographers2594534choreographers
chorographers24106124c_horographers
cosmographers2353594c_osmographers
cryptograms2153714cryptogra___ms
hydrographers2654154_hydrographers
mythographers2793634_mythographers
photographers2457164_photographers
physiographers2863404physiographers
reprographer2056254_reprographer_
topographers2055074_top_ographers
typographer2255344_typ_ographer_
xylographers2853814_xy_lographers
bibliographers2462535bibliographers
biogeographers2382915biogeographers
biographers19155115___biographers
calligraphers2162225c_alligraphers
cartographies2156045c_artographies
chirographer23106065c_hirographer_
choreographer2495745choreographer_
chorographer23118245c_horographer_
chromatographer28213575chromatographer_
cosmographer2254885c_osmographer_
cryotherapies2362775cryotherapie_s
cryptogamous2262085cryptog_a_mous
cryptogams2052695cryptog_a___ms
cryptogram2053965cryptogra____m
cryptorchids2592315crypto_r_chids
cymographs2397005c_y_mograph__s
demographers2154565__demographers
discographers2253195_discographers
epigraphers1953405__ep_igraphers
ethnographers2293585_ethnographers
geographers1854785___geographers
glossographers2161765glossographers
hagiographers2353745_hagiographers
holographers2166225__holographers
hydrographer2555795_hydrographer_
iconographers2153635_iconographers
lexicographers29172195lexicographers
lithographers2253905_lithographers
mythographer26124515_mythographer_
oceanographers2262295oceanographers
paleographers21114245_paleographers
petrographers2155075_petrographers
phonographers2465795_phonographers
photographer2349685_photographer_
physiographer2754345physiographer_
pornographers2164485_pornographers
reprographics2395175_reprographics
reprographies2196095_reprographies
scenographers2173625_scenographers
seismographers22142685seismographers
stenographers19104095_stenographers
thermographers2553685thermographers
topographer1946695_top_ographer_
typographed2354685_typ_ographe_d
typographies23105665_typ_ographies
typographs2196485_typ_ograph__s
videographers2353405_videographers
xylographer2754835_xy_lographer_
zoogeographers3062375zoogeographers

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 Filter178691950240.1261418182.5
2DLD Change Limit95024737.32612970.8
3Display Results73730.0461587.0
 (SQL Overall)178691737.49823831.8
 
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.