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

67 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
rechoreographed2710224(None) 
choreographed25104822__choreographed
rechoreograph2483072rechoreograph__
rechoreographs2572952rechoreograph_s
unchoreographed2771692unchoreographed
choreographer2495743__choreographer
rephotographed2663223repho_tographed
choreograph2256154__choreograph__
choreographers2594534__choreographers
choreographic2655874__choreographic
choreographies2555274__choreographies
choreographs2356194__choreograph_s
choreography2656004__choreograph_y
chorographer23118244__chor_ographer
chirographer23106065__chir_ographer
choreographing2663295__choreographing
chorographers24106125__chor_ographers
chorographic2548555__chor_ographic
chorographies2487435__chor_ographies
chorography2548455__chor_ograph_y
hectographed2454545hec___tographed
holographed21107625___ho_lographed
micrographed2365945mic__r_ographed
photographed2458665__pho_tographed
rephotograph2364185repho_tograph__
rephotographs2464035repho_tograph_s
reprographer2056255re__pr_ographer
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
ethnographer2184786_eth__nographer
heliographed2275516___heliographed
historiographer2471936historiographer
holographer2088396___ho_lographer
iconographer2054896_ic_o_nographer
lithographed2254386lith___ographed
mimeographed2353736___mimeographed
monographed2046556___mo_nographed
petrographer2057286pe__tr_ographer
phonographer2347866__pho_nographer
photographer2349696__pho_tographer
phytogeographer3072376phytogeographer
pornographer2056016___pornographer
radiographed2065126r___adiographed
rechromatograph2882416rechromatograph__
rephotographing2772016repho_tographing
reprogramed1763766re__pr_ogra_med
reprogrammed2063016re__pr_ogrammed
reprographers2154666re__pr_ographers
reprographic2296656re__pr_ographic
reprographies2196096re__pr_ographies
reprography2246526re__pr_ograph_y
retrograded1453106re__tr_ogra_ded
telegraphed1853866te___le_graphed
thermographer2464886__thermographer
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.360496363.9
2DLD Change Limit95024678.92310649.3
3Display Results67670.0461456.5
 (SQL Overall)178691679.32919154.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.