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

179 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
slighter125782(None) 
blighter1466851blighter
lighter113113431_lighter
plighter1476621plighter
sighter113412101s_ighter
slighted1357391slighted
slighters1346701slighters
alighted1347672alighted
blighted1546862blighted
blighters1555732blighters
brighter1476662brighter
delighter1445582delighter
fighter143010762_fighter
flichter1664962flichter
flighted1646972flighted
flightier1644422flightier
lighted122913502_lighted
lighten112811522_lighten
lighters123111382_lighters
plighted1546462plighted
plighters1545522plighters
righter113212372_righter
sigher103813702s_igh_er
sighted123111522s_ighted
sighters122510592s_ighters
slaughter1344002slaughter
sleigher1234312sleigh_er
slight103416002slight__
slightest13136942slightest
slightly1544602slightly
slights112810722slight_s
slither104112982slith_er
slitter73615872sli_tter
tighter112910682_tighter
weighter1535602weighter
alight103816863alight__
alights113211433alight_s
aligner8108313alig_ner
bighted142810923_bighted
blight124114623blight__
blighties1546223blighties
blights133110213blight_s
blighty16356843blight_y
blister94415313bli_ster
blither124812173blith_er
brighten1466243brighten
daughter1344503daughter
delighted1546203delighted
delighters1544363delighters
dighted132511493_dighted
enlighten1344353enlighten
fighters15269393_fighters
flichters1774173flichters
flight134014813flight__
flights143310983flight_s
flighty17347433flight_y
flirter10318673fli_rter
flitter103413903fli_tter
freighter1655023freighter
frighted1657173frighted
frighten1566443frighten
glister84013343gli_ster
glitter84211803gli_tter
heighten1545703heighten
higher134610893_high_er
highted152710163_highted
infighter1644273infighter
klister113410643kli_ster
knighted1745123knighted
laughter1245113laughter
lichted13268803_lichted
lifter93814813_li_fter
ligate72519243_ligate_
ligated92414133_ligated
ligates82318373_ligates
liger65024473_lig__er
light94429603_light__
lightener1345693_lightener
lightens12259993_lightens
lightered1446273_lightered
lightest121410353_lightest
lightly14369023_lightly
lights104519913_light_s
limiter92710853_limiter
linter64625343_li_nter
lister64527253_li_ster
liter54736343_li__ter
lither94520953_lith_er
litter64324853_li_tter
mightier1436383_mightier
mislighted1743653mislighted
nigher103612753_nigh_er
oligomer1144023oligomer
plight123513363plight__
plights13299313plight_s
relighted1436863relighted
righted122912143_righted
righters122610703_righters
salimeter1157373salimeter
scimiter1236143scimiter
shifter132911073shi_fter
sifter94516233s_i_fter
sighed113712053s_igh_ed
sighers113712173s_igh_ers
sight94629293s_ight__
sightlier1344453s_ightlier
sightly14408273s_ightly
sights103818013s_ight_s
sightsee1245473s_ightsee
sightseer1343313s_ightseer
signer74015633s_ig_ner
silenter838873silenter
sinter63625923s_i_nter
sister64421583s_i_ster
sitter63323383s_i_tter
skirter11338483ski_rter
skitter113810393ski_tter
skylighted2251803skylighted
slaggier10126953slaggier
slasher104515323slash_er
slater64429183sl__ater
slather103816063slath_er
slaughters1443533slaughters
sleighed1334033sleigh_ed
sleighers1343703sleigh_ers
sleight11279023sleight__
sleights12275913sleight_s
slicer84117603sli__cer
slicker133314533sli_cker
slickster1543413slickster
slider73918363sli__der
slier54827243sli___er
slighting1436373slighting
slightness1454803slightness
slimier93212013sli_mier
slimmer114211343sli_mmer
slimsier1085213slimsier
slinger83413833sli_nger
slinkier12206933slinkier
slipover1343833slipover
slipper113712973sli_pper
slippier1256533slippier
slithers114212953slith_ers
slithery14356703slith_ery
slitted83513313sli_tted
slitters84014133sli_tters
slittier837003slittier
sliver94116593sli__ver
sliverer11237633sliverer
slogger94310483slog_ger
sloshier1135283sloshier
slotter73314443sl_otter
sloughier1343673sloughier
slugger93610673slug_ger
slushier1135983slushier
smiter83616413smi__ter
snifter10349623sni_fter
snigger9328373snig_ger
sniggler10396113sniggler
songster935783songster
spinster1036683spinster
spitter94015183spi_tter
splinter10329703spli_nter
splitter10348443spli_tter
stinter73614513sti_nter
straighter1444483straighter
suiter64121813sui__ter
swifter13318053swi_fter
swigger12338453swig_ger
swisher13369523swish_er
swishier1434563swishier
swither133710993swith_er
tighten11288973_tighten
unlighted1455773unlighted
uplighted1653843uplighted
weigher14136343weigh_er
weighted1635593weighted
weighters1644663weighters
weightier1643313weightier

Search took 10 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.1731032896.0
2DLD Change Limit1461621798.95316325.5
3Display Results1791790.0632841.3
 (SQL Overall)1786911799.18919446.2
 
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.