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

149 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
sklented133505(None) 
relented92614942relented
scented102811882s_cented
selected1159782selected
silenced1136272silenced
silenter838872silenter
sklent103614352sklent__
sklents11348162sklent_s
slanted83514742s_lanted
sleeted83113222s_leeted
splinted11369252splinted
talented938422talented
absented1156613absented
accented13107773accented
agented939423_agented
alerted82512223_alerted
assented957513assented
bleated104015973_bleated
blended114710713_blended
blunted104210663_blunted
cemented1338373cemented
cleated103417843_cleated
clefted13326753_clefted
deleted93314903dele_ted
demented12311273demented
dented84120513__dented
elected102812613_elected
fileted1159093file_ted
fleeted113310233_fleeted
flensed1136613_flensed
flinted114411893_flinted
fomented1437803fomented
galeated104111573galeated
gleeted9379323_gleeted
glinted9399373_glinted
hented104218753__hented
incented112412543incented
indented101811733indented
invented122510663invented
isleted837523isle_ted
keened114013623_keen_ed
kenned114411263_k_enned
kente95821063_k_ente_
kentes105118643_k_entes
lamented1138193lamented
lenited8812433__lenited
lensed74015473__lensed
lenten6312883__lenten
letted74118543__letted
linted74021823__linted
lunted74517523__lunted
molested11178243molested
oriented937483oriented
parented11912213parented
patented1188893patented
pileated112711133pileated
planted103516123_planted
pleated103816633_pleated
rented74426593__rented
repented112614983repented
rerented92516163rerented
resented92716963resented
sainted84114243s_ainted
salted74121203sal__ted
saluted84511713sal_uted
scanted104114393s_canted
scended11329873s_cended
seated75131053s__eated
segmented1345063segmented
selectee10910493selectee
selenate81712523selenate_
selenates91611353selenates
selenide9158863selenide
selenite81713103selenite_
selenites91312083selenites
sended85121233s__ended
sensed73918163s__ensed
sente56432873s__ente_
sheened113511703sheen_ed
sheeted113813043s_heeted
shlepped1633643shlepped
shunted11339783s_hunted
signeted1035973signeted
silence9310213silence_
silencer1036293silencer
silences10310073silences
silent64125843silent__
silentest948103silentest
silently1147483silently
silents73514493silent_s
silted74020013sil__ted
skanked11338103sk_anked
skated114414883sk__ated
skeed105018983sk_e__ed
skeeter113410413sk_eeter
skeined1236773sk_eined
skelped1435203sk_elped
skelter113610003sk_elter
skene96118123sk_en_e_
skenes104616633sk_en_es
skewed145610233sk_e_wed
skinked11339013sk_inked
skinned12387293sk_inned
skirted12388613sk_irted
skited114313483sk__ited
sklenting1475123sklenting
skunked11316193sk_unked
slanged94112853s_langed
slated75028313s_l_ated
slatted84015183s_latted
sleaved113611133s_leaved
sledded10378873s_ledded
sledged103610313s_ledged
sleeked123510883s_leeked
sleeved11419913s_leeved
slender83413593s_lender
sleuthed1233813s_leuthed
slewed104815523s_le_wed
slinked123011383s_linked
slitted83513313s_litted
slotted84613883s_lotted
smelted10399093s_melted
solated83618023sol_ated
solenoid947873solenoid
solvated12237443solvated
sonneted936183sonneted
splatted11356743splatted
splendid1244643splendid
splent84720193splent__
splents93912133splent_s
splined105013113splin_ed
splinter10329703splinter
sprinted113411163sprinted
squinted1847063squinted
stetted82610403s_tetted
stinted82914193s_tinted
strunted957243strunted
stunted83010403s_tunted
sulcated11310373sulcated
sulfated1238833sulfated
sweated113411543s_weated
telneted935073telneted
tented74221003__tented
undented102313953undented
unletted9310313unletted
unrented92413923unrented
untented92613413untented
valeted1139013vale_ted
vented104617923__vented

Search took 9 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 Filter1786911461620.186960704.3
2DLD Change Limit1461621498.34617512.8
3Display Results1491490.0463239.1
 (SQL Overall)1786911498.57820831.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.