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

39 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
goddamn124267(None) 
goddam1145161goddam_
goddamns1341981goddamns
goddams1233981goddams
goddamned1541232goddamned
goldarn944382goldarn
goodman1135932goodman
bedamn1137813_bedamn
bondman1238043bondman
condemn1237113condemn
damn75724323___damn
giddap1143413gidda_p
goban84414073go_ba_n
goddammed1751013goddammed
goddamming1851073goddamming
goddamning1651183goddamning
godded104811803godd_ed
goddess1035263goddess
godding113911943godding
godown1136033go_down
godroon946043godroon
godson857383go_dson
goldarns1043593goldarns
golden84411153gold_en
goldurn943333goldurn
goodmen1135623goodmen
gossan747233gossa_n
gourami1083803gourami
gowan95415743go_wa_n
hodden113811453hodd_en
hoddin11369943hodd_in
jordan1468063jorda_n
ordain7810403_ordain
rodman949713rodma_n
rodsman1036653rodsman
sodden84011513sodd_en
soldan73511853solda_n
soudan73210353souda_n
woodman1336313woodman

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 Filter1786911340270.423422437.4
2DLD Change Limit134027397.26618445.8
3Display Results39390.0133000.0
 (SQL Overall)178691397.70223200.6
 
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.