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

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

54 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
unchoreographed277169(None) 
choreographed25104822__choreographed
rechoreographed27102242rechoreographed
choreographer2495743__choreographer
choreograph2256154__choreograph__
choreographers2594534__choreographers
choreographic2655874__choreographic
choreographies2555274__choreographies
choreographs2356194__choreograph_s
choreography2656004__choreograph_y
chorographer23118244__chor_ographer
rechoreograph2483074rechoreograph__
rechoreographs2572954rechoreograph_s
chirographer23106065__chir_ographer
choreographing2663295__choreographing
chorographers24106125__chor_ographers
chorographic2548555__chor_ographic
chorographies2487435__chor_ographies
chorography2548455__chor_ograph_y
holographed21107625___ho_lographed
micrographed2365945mic__r_ographed
photographed2458665__pho_tographed
rephotographed2663225repho_tographed
stereographed2053905__stereographed
biogeographer2273586__biogeographer
cartographer2096116__c_artographer
chirographers2494696__chir_ographers
chirographic2556376__chir_ographic
chirographies2465906__chir_ographies
chirography2546136__chir_ograph_y
chromatographed29163366__chromatographed
chronograph22146076__chronograph__
chronographic2655516__chronographic
chronographies2574936__chronographies
chronographs23145846__chronograph_s
chronography26125746__chronograph_y
cosmographer2254886__c_osmographer
hectographed2454546___hectographed
heliographed2275516___heliographed
historiographer2471936historiographer
holographer2088396___ho_lographer
iconographer2054896_ic_o_nographer
incorporated1754546inc_orpo_ra_ted
lithographed2254386lith___ographed
mimeographed2353736___mimeographed
monographed2046556___mo_nographed
phonographer2347866__pho_nographer
photographer2349696__pho_tographer
phytogeographer3072376phytogeographer
pornographer2056016___pornographer
thermographer2464886__thermographer
uncorroborated1971256unc_orrobora_ted
unprogrammed2062016un__pr_ogrammed
zoogeographer2962786__zoogeographer

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 Filter178691950240.720248181.9
2DLD Change Limit95024548.78010822.8
3Display Results54540.0331636.4
 (SQL Overall)178691549.53318744.5
 
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.