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

44 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
photogravures227219(None) 
photogravure2182321photogravure_
rotogravures1661122_rotogravures
photographers2457173photographers
photographies2459413photographies
rotogravure1561103_rotogravure_
phonographers2465804phonographers
phonographies2447474phonographies
photoengravers2391664photoengraver_s
photoengraves2292704photoengrav__es
photograms1848194photogra___ms
photographed2458664photogra_phed
photographer2349694photogra_pher
photographs22411474photogra__phs
photoreduces2072964photo_reduces
chorographers24106125chorographers
chorographies2487435chorographies
gravures1234905_____gravures
holographers2166225_holographers
holographies2148125_holographies
phonograms1845705phonogra___ms
phonographer2347865phonogra_pher
phonographs2248905phonogra__phs
photoengrave2172815photoengrav__e_
photoengraved2382135photoengrav__ed
photoengraver2282315photoengrav__er
photoengravings2591335photoengravings
photoflashes2353075photofla_shes
photogenes1648885photog___enes
photogram1748235photogra____m
photograph21411015photogra___ph
photographic25410315photogra_phic
photographing2565985photographing
photography25410075photogra__phy
photophases2157945photopha__ses
photophores2159105photo__phores
photoproducts2362395photoproducts
photoreduce1962835photo_reduce_
photoreduced2162245photo_reduced
photospheres2255805photo_spheres
phototaxes2246665photo_ta__xes
phototaxies2356225photo_ta_xies
phototubes1754365photo___tubes
pictographies2355635pictographies

Search took 10 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 Filter1786911247900.406440125.6
2DLD Change Limit124790448.71614317.3
3Display Results44440.0331333.3
 (SQL Overall)178691449.15519518.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.