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

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

84 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
guides8411828(None) 
glides84518861glides
grides84422361grides
gudes74520811gu_des
guide75019881guide_
guided94014111guided
guider84313521guider
guiders94111111guiders
guids75516151guid_s
guiles73919281guiles
guises74216311guises
abides94719892abides
aides65336602_aides
amides95722662amides
asides75118872asides
azides165113802azides
bides85536772_bides
brides94423512brides
chides124620472chides
dudes75424372du_des
elides74420692elides
gaudies9311972gaudies
geodes8412152geodes
gibes84422522g_ibes
gids65933742g_id_s
gies55641422g_i_es
gites65630182g_ites
gives95324872g_ives
glades84820342glades
gledes84915132gledes
glide74521592glide_
glided94513902glided
glider84614262glider
gliders94811842gliders
glimes94717522glimes
gourdes9109382gourdes
grades84926312grades
gride75223582gride_
grided95117042grided
grids75321392grid_s
grimes94619032grimes
gripes94619872gripes
gude65423332gu_de_
guid66022822guid__
guidon837372guidon
guidons936622guidons
guilder945912guilder
guilders1035512guilders
guilds8388352guilds
guile64521132guile_
guiled84315382guiled
guilts74111232guilts
guimpes1245072guimpes
guinea737612guinea
guineas836752guineas
guiros7389092guiros
guise64717712guise_
guised84612172guised
gulden8328762gulden
guldens9356572guldens
gules64831042gu_les
gunites8313122gunites
gurges84716862gurges
gushes104719032gushes
hides95129422_hides
ides57734232__ides
imides94515342imides
irides74519122irides
juices1549422juices
ludes65728852lu_des
nides65229132_nides
nudes64723292nu_des
nudies75217092nudies
oxides14109692oxides
prides94324182prides
quids154917462quid_s
quires154015752quires
rides66140812_rides
sides65838362_sides
slides73922182slides
suedes73918112suedes
suites63727402suites
tides64830152_tides
wides94832822_wides

Search took 3 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 Filter178691825510.326548131.9
2DLD Change Limit82551842.29635954.3
3Display Results84840.0165250.0
 (SQL Overall)178691842.63867737.3
 
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.