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

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
goldurn94333(None) 
goldarn944381goldarn
goldurns1042601goldurns
goldarns1043592goldarns
golden84411152gold_en
golder84417602golder_
bolder94820933bolder_
bordure1035783bordure
bourn75518483bo__urn
colder95121853colder_
colour85915093colour_
colours95913443colours
column1038103col_umn
colure8314163col_ure
cothurn1245053cothurn
dolour75710133dolour_
dolours8438823dolours
durn56127633___durn
folder104317543folder_
folders113514393folders
foldup1233813foldu_p
foldups1332733foldups
gelder84613713gelder_
gelders93812573gelders
gilder84415533gilder_
gilders94212463gilders
gluon6311223g_l_uon
goddamn1242673goddamn
godown1136033go_down
godson857383go_dson
gold65430163gold___
goldbug1242103goldbug
goldbugs1342103goldbugs
goldest92411173goldest
goldeye1234643goldeye
golds75421313gold__s
goldtone1084603goldtone
golfer104411183golfer_
golfers114410083golfers
goliard936073goliard
goodman1135933goodman
goodmen1135623goodmen
gourd71011903go__urd
govern1036823go_vern
gulden8328763guld_en
holden104113953hold_en
holder104619653holder_
holders113715903holders
holdup1245183holdu_p
holdups1333593holdups
modern939523mo_dern
molder93819273molder_
molders103315553molders
mourn77215013mo__urn
nocturn944653nocturn
olden65114853_old_en
older65121173_older_
ordure756813_ordure
polder94019253polder_
polders103617373polders
rondure837313rondure
sojourn1442893sojourn
soldan73511853sold_an
solder73921343solder_
solders83517773solders
vodun937223vo_du_n
yourn87512773yo__urn

Search took 7 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.403443402.0
2DLD Change Limit134027676.53320515.4
3Display Results67670.0135153.8
 (SQL Overall)178691676.94925714.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.