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

146 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
plighter147662(None) 
blighter1466851blighter
lighter113113441_lighter
plighted1546461plighted
plighters1545531plighters
slighter1257821slighter
alighted1347672alighted
blighted1546862blighted
blighters1555742blighters
brighter1476662brighter
delighter1445582delighter
fighter143010772_fighter
flichter1664962flichter
flighted1646972flighted
flightier1644422flightier
lighted122913502_lighted
lighten112811522_lighten
lighters123111392_lighters
plight123513362plight__
plights13299312plight_s
righter113212382_righter
sighter113412112_sighter
slighted1357392slighted
slighters1346712slighters
tighter112910692_tighter
uplighted1653842uplighted
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
fighters15269403_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
lamplighter1951553lamplighter
laughter1245113laughter
lichted13268803_lichted
lifter93814813_li_fter
ligate72519253_ligate_
ligated92414143_ligated
ligates82318383_ligates
liger65024473_lig__er
light94429603_light__
lightener1345693_lightener
lightens122510003_lightens
lightered1446283_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
nigher103612753_nigh_er
oligomer1144023oligomer
painter93814563pai_nter
philter12108213phi_lter
piaster93012883p_iaster
piggier113510003p_iggier
pilaster1038163pilaster
pisher114317753p_ish_er
pithier123010293p_ithier
placater1238013placater
plaguer10328273plag_uer
plaister1068013plaister
plaiter93615393pl_aiter
plankter1435363plankter
planter94017803pl_anter
plasher124215033plash_er
plashier1337613plashier
plaster93318693pl_aster
plater84427693pl__ater
platter93917413pl_atter
pleater93916333pl_eater
pleather1356653pleather
plicate11314513plicate_
plicated13310643plicated
plier75221283pli___er
plighting1635563plighting
plinker134010963pli_nker
plotter94113663pl_otter
plougher14214463plough_er
plugger11378433plug_ger
plusher124010383plush_er
plushier1375193plushier
pointer93814933poi_nter
polisher1388073polish_er
politer92417073poli__ter
printer93917303pri_nter
privater13158533privater
relighted1436863relighted
righted122912143_righted
righters122610713_righters
sigher103813703_sigh_er
sighted123111523_sighted
sighters122510603_sighters
slaughter1344003slaughter
sleigher1234313sleigh_er
slight103416003slight__
slightest13136943slightest
slightly1544603slightly
slights112810723slight_s
slither104112983slith_er
slitter73615873sli_tter
splinter10329703spli_nter
splitter10348443spli_tter
tighten11288973_tighten
unlighted1455783unlighted
uplifter1363903upli_fter
uplight13167363uplight__
uplights14165053uplight_s
uprighted1654213uprighted
weigher14136343weigh_er
weighted1635593weighted
weighters1644673weighters
weightier1643313weightier

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621467.04620744.0
3Display Results1461460.0632317.5
 (SQL Overall)1786911467.54523683.4
 
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.