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

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

52 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
danegeld114283(None) 
danegelds1241771danegelds
danegelt1045091danegelt
danegelts1142442danegelts
daneweed1344052daneweed
danged94819482dan_ge_d
dangled104013152dan_gled
aneled74719273_anele_d
angel65019563_an_gel_
angeled93211493_an_geled
angels74416173_an_gels
angled84219073_an_gled
banged104923723ban_ge_d
canfield1444333canfield
daggled11329463da_ggled
damaged1257453damage_d
danced105315253dan_ce_d
dandered112110963dandere_d
dandled103313543dandle_d
daneweeds1442763daneweeds
danger83722823dan_ge_r
dangered11248513dangered
dangers94818213dan_gers
dangle84119303dan_g_le
dangler96912813dan_gler
dangles93618423dan_gles
dangly114212263dan_g_ly
davened124610073davene_d
dinged95221783din_ge_d
dunged95414693dun_ge_d
fanged114318223fan_ge_d
ganged94619193gan_ge_d
handheld1644463handheld
hanged114222393han_ge_d
jangled164111563jan_gled
managed113212603manage_d
manege94113203manege__
maneges103612143manege_s
mangel94017533man_gel_
mangels103614493man_gels
mangled113615253man_gled
mangold1137203man_gold
paneled10612573panele_d
panelled1138963panelled
panetela1044143panetela
panged104722333pan_ge_d
ranged84824313ran_ge_d
reneged92010763renege_d
tanged84622493tan_ge_d
tangelo837033tan_gelo
tangled94214633tan_gled
wangled123312413wan_gled

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162526.98320931.1
3Display Results52520.0301733.3
 (SQL Overall)178691527.16924925.5
 
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.