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

159 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
frighted165717(None) 
flighted1646971flighted
freighted1755201freighted
frighten1566441frighten
righted122912141_righted
affrighted2152052affrighted
alighted1347672alighted
bighted142810922_bighted
blighted1546862blighted
brighten1466242brighten
brighter1476662brighter
dighted132511492_dighted
farsighted1842942farsighted
fighter143010772f_ighter
fraughted1743602fraughted
freighter1655022freighter
frigate11311062frigate_
frigates12310932frigates
frigged13439052frig_ged
fright133715242fright__
frightened1843242frightened
frightens1655392frightens
frights14339622fright_s
fritted113611332fri_tted
highted152710162_highted
knighted1745122knighted
lighted122913502_lighted
plighted1546462plighted
righter113212382_righter
sighted123111522_sighted
slighted1357392slighted
uprighted1654212uprighted
weighted1635592weighted
aright103817663aright__
bedighted1744583bedighted
benighted1644743benighted
bigoted11258403_bigoted
blighter1466853blighter
brigaded1344573brigaded
bright124215923bright__
brightened1743163brightened
brightens1565373brightens
brightest1545663brightest
brightly1764553brightly
brights133710233bright_s
delighted1546203delighted
draughted1543693draughted
drifted12367953dri_fted
faggoted1443103faggoted
fagoted1236073f_agoted
fainted114211723fai_nted
faithed1437163faith_ed
feigned1245353feig_ned
feinted11379623fei_nted
fidgeted1443893fidgeted
figged124013893f_ig_ged
fight124027093f_ight__
fighters15269403f_ighters
fights133816553f_ight_s
figured12196473f_igured
fileted1159093f_ileted
fished134316313f_ish_ed
fisted104218703f_i_sted
fitted104716663f_i_tted
fixated1835533f_ixated
flichter1664963flichter
flight134014813flight__
flightier1644423flightier
flights143310983flight_s
flighty17347433flight_y
flinted114411893fli_nted
flirted11428673fli_rted
flited104616583fli__ted
flitted114011643fli_tted
foisted113210603foi_sted
foresighted1952903foresighted
foughten1544003foughten
fracted1339373fr_acted
fragged134010163frag_ged
freight1447603freight__
freighters1764123freighters
freights1555853freight_s
freshed143312593fresh_ed
fretted113411853fr_etted
fribbled16305743fribbled
fried95322913fri___ed
friended1335033friended
friges104116483frig__es
frightful1952553frightful
frighting1736023frighting
frigid1136923frig__id
frilled113911603fri_lled
fringed123611523fri_nged
frisked15478823fri_sked
frites94922483fri__tes
fritter103912773fri_tter
frivoled1534043frivoled
frized193510683fri__zed
frizzed19375973fri_zzed
frizzled20325703frizzled
frogeyed1642783frogeyed
frogged13408493frog_ged
fronted114011273fr_onted
frosted113211873fr_osted
frothed14288783froth_ed
frowsted1534313frowsted
frugged13387293frug_ged
fruited11389093fr_uited
fumigated1644723fumigated
grifted12379583gri_fted
gritted94110903gri_tted
heighten1545703heighten
irrigated1176313irrigated
lichted13268803_lichted
ligated92414143_ligated
lighten112811523_lighten
lighter113113443_lighter
neighed12135893neigh_ed
nighed113811293_nigh_ed
oriented937483oriented
oughted1236223_oughted
plighter1476623plighter
priested1138393priested
prigged12398933prig_ged
printed104016373pri_nted
relighted1436863relighted
resighted1436523resighted
rifted104115313_ri_fted
rigged94517403_rig_ged
right94430503_right__
righters122610713_righters
rightest12149583_rightest
righties12711573_righties
rightly14389043_rightly
righto104111093_right_o
rights104019333_right_s
righty135011833_right_y
rioted73416373_ri_oted
riveted11258573_riveted
sighed113712053_sigh_ed
sighter113412113_sighter
slighter1257823slighter
straighted1544863straighted
thighed1535273thigh_ed
tighten11288973_tighten
tighter112910693_tighter
trigged10359853trig_ged
unlighted1455783unlighted
unsighted1455433unsighted
uplighted1653843uplighted
urinated9311613urinated
waughted1643483waughted
weighed15135933weigh_ed
weighter1535603weighter
whishted1843153whishted
wriggled14284663wriggled
wright133713513wright__
wrights14318993wright_s
writhed14389623writh_ed

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.420425454.8
2DLD Change Limit1461621597.06320694.0
3Display Results1591590.0801987.5
 (SQL Overall)1786911597.56323627.0
 
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.