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

132 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
slighting143637(None) 
alighting1446411alighting
blighting1635731blighting
flighting1736101flighting
lighting132811831_lighting
plighting1635561plighting
sighting133110861s_ighting
bighting15269452_bighting
delighting1644992delighting
dighting142510842_dighting
fighting162710082_fighting
frighting1736022frighting
highting16259722_highting
knighting1844442knighting
lichting14268512_lichting
ligating102212282_ligating
lightings14277722_lightings
lightning14286022_lightning
mislighting1843412mislighting
relighting1545852relighting
righting132610852_righting
sighing123311662s_igh_ing
sightings14256532s_ightings
sleighing1434212sleigh_ing
slightingly1952262slightingly
slitting93012582sli_tting
uplighting1743362uplighting
weighting1744782weighting
aligning10158533alig_ning
bedighting1844163bedighting
blighties1546223blighties
claughting1742483claughting
daylighting2072063daylighting
eliciting1237773eliciting
fightings17276503_fightings
flightier1644423flightier
flightily1943353flightily
flinting123412343fli_nting
flirting12319013fli_rting
fliting113514613fli__ting
flitting123010883fli_tting
freighting1844543freighting
glinting103210053gli_nting
infighting1844413infighting
legating102313113_legating
lifting113313273_li_fting
lighten112811523_lighten_
lightening15255053_lightening
lightens122510003_lightens
lightering15246113_lightering
lightish1556623_lightish
lightnings15263803_lightnings
lilting83515383_li_lting
limiting1138813_limiting
linting83820983_li_nting
listing84020593_li_sting
lithoing1236743_lithoing
neighing1355523neigh_ing
nighing123410063_nigh_ing
obligating1445803obligating
oughting1335953_oughting
refighting1845193refighting
resighting1546073resighting
sainting93215733sai_nting
salivating1447433salivating
shifting152910383shi_fting
shirting123213613shi_rting
shitting123212663shi_tting
sifting113014593s_i_fting
sightline1345683s_ightline
signeting1136223s_igneting
signing92713963s_ig_ning
silting83320483s_i_lting
siting74126623s_i__ting
sitting83519633s_i_tting
skirting13289393ski_rting
skiting123812503ski__ting
slagging113711573slag_ging
slanting94115093sl_anting
slashing123713413slash_ing
slating83724653sl__ating
slatting94014233sl_atting
sleeting93114163sl_eeting
sleuthing1334203sleuthing
slicing103514643sli__cing
slicking153712593sli_cking
sliding93114553sli__ding
slight103416003slight___
slighted1357393slight_ed
slighter1257823slight_er
slighters1346713slighters
slightest13136943slightest
slightly1544603slight_ly
slights112810723slight__s
sliming102913953sli__ming
slimming13288093sli_mming
slinging103312863sli_nging
slinking133412983sli_nking
sliping103314413sli__ping
slipping133510663sli_pping
slithering1496893slithering
slivering1338083slivering
slogging113410493slog_ging
sloshing12258823slosh_ing
slotting92612613sl_otting
sloughing14244753slough_ing
slugging11339423slug_ging
slushing12299643slush_ing
smiting103014443smi__ting
sniggling1244413sniggling
soliciting1346813soliciting
soughing13259733sough_ing
spiriting1238413spiriting
spirting112913633spi_rting
spiting103917623spi__ting
spitting113012323spi_tting
splinting1238193spli_nting
splitting1236563spli_tting
spotlighting1951583spotlighting
stilting93312403sti_lting
stinting93415743sti_nting
stithying1643703stithying
straighting1644073straighting
sughing12359713s_ugh_ing
suiting83419003sui__ting
swigging14337223swig_ging
swishing15277813swish_ing
unsighting1584443unsighting
uprighting1743463uprighting
waughting1743123waughting
weighing1635283weigh_ing
whishting1983563whishting

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411327.81319024.8
3Display Results1321320.0462869.6
 (SQL Overall)1786911328.01522294.6
 
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.