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

80 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
unknots114430(None) 
unknits1135551unknits
unknot1037411unknot_
beknots1335082beknots
inkpots1335172inkpots
knots95614722__knots
reknots1136782reknots
unknit1068592unknit_
unknown1442672unknown
unknowns1542142unknowns
unroots738562unroots
anklets114310413anklets
annoys967523an_noys
banknote1444833banknote
banknotes1544313banknotes
beknot1239763beknot_
bowknots1743063bowknots
bunkos124210323bunk_o_s
endnote855743endnote
endnotes945943endnotes
enroots738713enroots
gunshots1244373gunshots
ingots7912063in_gots
inkblots1442663inkblots
inkpot1237813inkpot_
junkets18377623junk_ets
knits93914743__knits
knobs11519713__knobs
knops115911813__knops
knot85630503__knot_
knouts10438313__knouts
knows124912413__knows
ninons64913773_ninons
nonets64118703_nonets
pinots85920273_pinots
punnets9409263pun_nets
reknits1137073reknits
reknot10311733reknot_
snoots64216683sn_oots
snots55225123__snots
sunkets113511283sunk_ets
sunspots1045083sunspots
topknots1443303topknots
unbelts9237663unbelts
unbolts9247803unbolts
unclogs1036803unclogs
uncos74117033un_co_s
uncross938193uncross
undoes73917403un_does
unfits93910293un_fits
ungot61718063un_got_
unhats91110623un_hats
unhoods1137503unhoods
unhooks1436413unhooks
unions64216753un_ions
unipods1095703unipods
unisons748423unisons
units54923433u__nits
unkent103116053unkent_
unkept123710873unkept_
unkinks10265413unkinks
unknotted1443623unknotted
unmoors945903unmoors
unnoisy1044243un_noisy
unnoted8311363un_noted
unquote1645903unquote
unquotes1745353unquotes
unrests7229463unrests
unroofs1035783unroofs
unroot6315553unroot_
unseats73012853unseats
unsets64116163un_sets
unsnags835463unsnags
unsnaps935423unsnaps
unstops936993unstops
unwits9389893un_wits
uproots937143uproots
upshots1235193upshots
uranous7310733uranous
urinous7310083urinous

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.390458182.1
2DLD Change Limit134027806.37621020.5
3Display Results80800.0302666.7
 (SQL Overall)178691806.79626293.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.