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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

168 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
clade8582101(None) 
blade85923331blade
cade76443911c_ade
clad76225821clad_
clades94920461clades
clads85722731clads
clave105420151clave
glade75121961glade
lade56345981_lade
alae45643752ala_e
alane56135612alane
alate55340332alate
alcade91111512alcade
bade75140882_bade
bladed104717762bladed
blader93618582blader
blades95221252blades
blae66134642bla_e
blame95625492blame
blare75826232blare
blase75524232blase
blate75933782blate
blaze165520832blaze
cad67456362c_ad_
cades85440732c_ades
cadet85339342c_adet
cadge94018792c_adge
cadi75732182c_adi
cadre85419022c_adre
cads76144522c_ads
cafe95230322c_afe
cage75339062c_age
cake105439962c_ake
calve105919922calve
came87648752c_ame
cane66653122c_ane
cape87242782c_ape
care66968372c_are
case65848082c_ase
cate66254602c_ate
cave95941262c_ave
cease75227652cease
cede74928772c_ede
chad105525502chad_
chads116122232chads
chafe135117352chafe
chape125221142chape
chare105231982chare
chase105127122chase
chide115321012chide
clach124617822clach
clack134720172clack
cladded12356922cladded
cladode1134612cladode
clag75924572cla_g
clags85621122clags
claim95616912claim
clam86332292cla_m
clamp115517652clamp
clams95127672clams
clan65633922cla_n
clang86019312clang
clank114719522clank
clans75031012clans
clap86429042cla_p
claps95626182claps
clapt98027172clapt
claque17338562claque
claret84026572claret
claro75018692claro
clary105719612clary
clash106219032clash
clasp95517192clasp
class75525482class
clast76030582clast
clause84311502clause
claver113816972claver
claves115020062claves
clavi104912922clavi
claw95624342cla_w
clawed125115072clawed
clawer114512782clawer
claws106020832claws
clay95927412cla_y
clayed125013042clayed
clayey14407662clayey
clays105521332clays
cleave114212512cleave
clepe94617382clepe
clime95720892clime
cline76428532cline
clod76124612clod_
clods85320862clods
clone75728162clone
close76425222close
clove105619442clove
cloze165517542cloze
clue65324532cl_ue
clued84917682clued
code77347732c_ode
comade114415322comade
coude85022632coude
cradle93313162cradle
crake114823522crake
crane75331602crane
crape96128442crape
crate76537402crate
crave105626312crave
craze165221462craze
crude86018572crude
elate55335882elate
elide64922642elide
elude64517622elude
evade938182evade
fade85736342_fade
flake125119972flake
flame105124442flame
flare84823632flare
glace87420162glace
glad65624012glad_
glades84820342glades
glads75620612glads
glady105413942glady
glare65222962glare
glaze155418162glaze
glede75517832glede
glide74521592glide
grade75126092grade
hade85440192_hade
irade65618152irade
jade125325442_jade
lace66848472_lace
lad48165702_lad_
laded74232612_laded
laden65022192_laden
lader65633722_lader
lades65141272_lades
ladle66320442_ladle
lads56549132_lads
lady86527152_lady
lake85741602_lake
lame66849292_lame
lane45153332_lane
lase46148512_lase
late47560482_late
lave75642142_lave
laze136235052_laze
lode56240112_lode
lude55331642_lude
made75440242_made
place94824612place
plage84520402plage
plane74929142plane
plate74635112plate
sade55544472_sade
scalade10359262scalade
shade95125582shade
slake93724052slake
slate55438282slate
slave84224032slave
slide64725412slide
spade84423322spade
stade64825302stade
trade65026042trade
tsade64311122tsade
unlade72714152unlade
wade85237062_wade
yclad11246382yclad_

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.313570897.8
2DLD Change Limit538001681.57634137.1
3Display Results1681680.0463652.2
 (SQL Overall)1786911681.93592346.8
 
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.