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

88 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
suede6441975(None) 
sued56537931sued_
sueded84014631sueded
suedes73918111suedes
swede94413201swede
brede85520502brede
cede74928772_cede
cued76329562cued_
dude65629662du_de
duende836922duende
glede75517832glede
gude65423332gu_de
guide75019882guide
hued86925852hued_
lude55331642lu_de
nude56626272nu_de
queue143711232queue
rede55037672_rede
rude55632782ru_de
rued55729792rued_
sade55544472s_ade
scene77220572scene
secede93311992secede
seder64826762s_eder
sedge75019972s_edge
see35772262s_e_e
seed55549482seed_
seeded84520462seeded
seeder74320772seeder
seeds64330062seeds
seedy94821532seedy
seme65836652s_eme
sene46848052s_ene
sere46153472s_ere
shade95125582shade
shed86536152shed_
sheds96122702sheds
side55444492s_ide
siege66718442siege
sieve84918842sieve
skee85431472ske_e
skeed105018982skeed
skene96118122skene
sled55334372sled_
sledge85011302sledge
sleds64418852sleds
slide64725412slide
slued64220512slued_
sned56026052sned_
sneds65715352sneds
snide64318722snide
sonde64622832sonde
spade84423322spade
sped76031492sped_
speed85526622speed
spode84617702spode
spued84918472spued_
stade64825302stade
steed66024942steed
stele55026842stele
stere55328542stere
suave83519872suave
subdeb1137522subdeb
subdue9128492subdue
sucre75019102sucre
sudd64719772su_dd
sudden83310832sudden
sudds75513592sudds
suds56135292su_ds
sue35651462su__e
suer45334032sue_r
suers55128482suers
sues46247652sue_s
suet46754822sue_t
suets55126102suets
suety85318492suety
suite54829562suite
sundae7312872sundae
sunder74019822sunder
sundew10369692sundew
supe65932762su_pe
surd56433812surd_
surds65624662surds
sure45447412su_re
surge65027692surge
swedes102711892swedes
unde55825482_unde
used55722822used_

Search took 2 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 Filter178691538000.310576422.6
2DLD Change Limit53800881.62633087.3
3Display Results88880.0302933.3
 (SQL Overall)178691881.96690890.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.