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

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

201 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
scythe1446601(None) 
scathe114414991scathe
scythed16385301scythed
scythes15356521scythes
kythe15509672_kythe
saithe94713912saithe
scathed134012642scathed
scathes124515712scathes
scute75520942scut_e
scyphi1643172scyphi
seethe93712482seethe
snathe94415112snathe
soothe94214842soothe
spathe115115692spathe
swathe125514112swathe
swithe124010682swithe
tythe115210452_tythe
ache96829823ac__he
acute74720363acut_e
bathe105822883_bathe
blithe115810863blithe
byte96521813_byt_e
cache125122483_cache
cate66254593_cat_e
cete64934783_cet_e
cite65640343_cit_e
cither114616683_cither
clothe114712993clothe
cote66648733_cot_e
cute66440453_cut_e
cutie76925923_cutie
cycle1239523_cycle
cymae126713013_cymae
cyme119420373_cy_me
cypher16306593_cypher
cyton101511463_cyton
eche97520283ec__he
ectype1334283ectype
flyte115713943flyt_e
fytte1138583_fytte
hyte109018943_hyt_e
kithe125917453_kithe
kyte117017763_kyt_e
kythed17407313_kythed
kythes16499133_kythes
lathe85626713_lathe
lecythi1542433lecythi
lethe85717303_lethe
lithe84922013_lithe
loathe94211383loathe
myth126715433_myth_
myths135911603_myths
mythy16568673_mythy
oocyte1135753oocyt_e
prythee1545383prythee
psyche1674293psyche
rathe85821923_rathe
rhythm1742873rhythm
sadhe94815133s_adhe
saith85826553saith_
saltie63422423saltie
sate45556103s_at_e
saute55028083saut_e
scale74629143sc_ale
scape96921843sc_ape
scarce104013633scarce
scare75334463sc_are
scat65848373scat__
scats75930603scat_s
scatt76030093scat_t
scatted103512773scatted
scatter93815173scatter
scatts85914663scatts
scatty115310653scatty
scene77220573sc_ene
sceptre1135043sceptre
scheme1379633scheme
schmoe13328333schmoe
schtik15185413schtik
sconce104711723sconce
scone74621833sc_one
scope94821483sc_ope
score75526733sc_ore
scot66242603scot__
scotch13207513scotch
scotched16187933scotched
scotches15179473scotches
scoter83815473scoter
scotia8310783scotia
scots74025903scot_s
scottie937443scottie
scouse84113633scouse
scouth115011153scouth_
scouther1356943scouther
scouths12527893scouths
scrape105917573scrape
scree720031703sc_ree
scribe104613523scribe
scrive115414943scrive
scut65835543scut__
scuta75815753scut_a
scutage1036333scutage
scutate9310323scutate
scutch13247083scutch
scutched16186893scutched
scutcher15176963scutcher
scutches15168883scutches
scutes85219193scutes
scuts74522523scut_s
scutter93512173scutter
scuttle936463scuttle
scutum1036363scutum
scyphate1843273scyphate
scyphus1743203scyphus
scything17264883scything
seethed113410193seethed
seethes103613743seethes
seiche11811833seiche
sente56432873sent_e
setae56026223s_etae
settee63721023settee
settle63915663settle
she66837693s___he
sheathe1348983sheathe
shote85526083shot_e
shute84520343shut_e
sidhe95315103s_idhe
site47052413s_it_e
sith75435153s_ith_
sixte126216583sixt_e
sixth155512233sixth_
sixths16416373sixths
skate94721543skat_e
skite95120043skit_e
slate55438283slat_e
slather103816063slather
slither104112983slither
sloth85019443sloth_
sloths94911883sloths
slype105112363sly_pe
smite75224863smit_e
smith107818043smith_
smiths114711023smiths
smithy14508273smithy
smote75820273smot_e
smother123510203smother
snath86419803snath_
snathes104816493snathes
snaths95112913snaths
snye77115493sny__e
softie93312473softie
sooth85924053sooth_
soothed113712733soothed
soother104215033soother
soothes103917103soothes
sooths95715583sooths
sortie63621983sortie
soth75932513s_oth_
soths86218623s_oths
south85223573south_
southed114313993southed
souther104116303souther
souths95216603souths
spate74731583spat_e
spathed134013183spathed
spathes125116533spathes
spite75430663spit_e
staithe1037723staithe
state56237333stat_e
statue66015323statue
stithy12398213stithy
stye76218973s__tye
style85519363sty_le
stymie1137623stymie
subtle82113433subtle
suite54829563suit_e
suttee63721543suttee
swath115920383swath_
swathed144611933swathed
swather134213593swather
swathes134115513swathes
swaths125312643swaths
swith115917403swith_
swither133710993swither
syce95820283s_y_ce
sycee105018623s_ycee
syke115420563s_y_ke
syne75725763s_y_ne
synth113711823synth_
synths12377883synths
syph125413273s_yph_
sypher14317083s_ypher
syphs13519453s_yphs
teethe94511313teethe
the67436053___the
tithe85319703_tithe
tythed13457503_tythed
tythes12419703_tythes
withe115220233_withe
writhe125310703writhe
wyte106018643_wyt_e

Search took 8 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162017.75014544.0
3Display Results2012010.0633190.5
 (SQL Overall)1786912017.95322468.4
 
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.