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

161 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
blade8592333(None) 
bade75140881b_ade
bladed104717761bladed
blader93618581blader
blades95221251blades
blae66134641bla_e
blame95625491blame
blare75826231blare
blase75524231blase
blate75933781blate
blaze165520831blaze
clade85821011clade
glade75121961glade
lade56345981_lade
ablate82219212ablate
ablaze17239832ablaze
abrade9313052abrade
alae45643752ala_e
alane56135612alane
alate55340322alate
alcade91111512alcade
baaed85218162baaed
babe86835812b_abe
bad67763152b_ad_
badge94819682b_adge
bads77048862b_ads
bake105637512b_ake
bald76432902bald_
balded105417512balded
balder95318862balder
balds85524642balds
baldy115518932baldy
bale66353842b_ale
baled85436442baled
ballade104012562ballade
bane65250422b_ane
barde85330772barde
bare65460522b_are
base64847022b_ase
bate66552422b_ate
bead75937922bead_
beaded104922422beaded
beader94623792beader
beadle93314682beadle
beads85429502beads
beady114719922beady
belady12489932belady
bide76041472b_ide
blab86629132bla_b
blabs95619632blabs
black134719072black
bladder11429152bladder
bladers104214682bladers
blaff135216482blaff
blah98625062bla_h
blahs105616512blahs
blain75421792blain
blam86131702bla_m
blamed116017952blamed
blamer104417142blamer
blames105121862blames
blams95023852blams
bland85320452bland
blander103715162blander
blank115418552blank
blared95018242blared
blares85021632blares
blast76532572blast
blat66550952bla_t
blats75132502blats
blaw97026722bla_w
blawed124713892blawed
blawn106813702blawn
blaws105620462blaws
blazed184314712blazed
blazer174414022blazer
blazes174817352blazes
bled75729312bled_
bleed85019802bleed
blende95413442blende
blite76225352blite
bloke114316632bloke
blonde94813292blonde
bludge104210972bludge
blue65328462bl_ue
blued84520322blued
blume95619892blume
blype12429672blype
bode75838752b_ode
bolide9515562bolide
brace95629272brace
brad75234342brad_
brads85528292brads
brae65639112bra_e
brake116025342brake
brave104925502brave
braze165423452braze
brede85520502brede
bride86425532bride
cade76443912_cade
clad76225822clad_
clades94920462clades
clads85722732clads
clave105420152clave
elate55335882elate
elide64922642elide
elude64517622elude
evade938182evade
fade85736342_fade
flake125119972flake
flame105124442flame
flare84823632flare
glace87420152glace
glad65624012glad_
glades84820342glades
glads75620612glads
glady105413942glady
glare65222952glare
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
lane45153322_lane
lase46148512_lase
late47560482_late
lave75642142_lave
laze136235052_laze
lode56240112_lode
lude55331642_lude
made75440232_made
oblate82214742oblate
place94824612place
plage84520402plage
plane74929142plane
plate74635112plate
sade55544472_sade
shade95125582shade
slake93724052slake
slate55438282slate
slave84224032slave
slide64725412slide
spade84423322spade
stade64825302stade
trade65026042trade
tsade64311122tsade
unlade72714152unlade
wade85237062_wade

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.0931921408.6
2DLD Change Limit538001611.65632487.9
3Display Results1611610.0463500.0
 (SQL Overall)1786911611.79599549.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.