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

259 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
lichting1426851(None) 
lighting132811831lighting
alighting1446412alighting
bighting15269452bighting
blighting1635732blighting
dighting142510842dighting
eliciting1237772eliciting
fighting162710082fighting
flighting1736102flighting
highting16259722highting
leching134613652lech_ing
lichening1545672lichening
licking144118282lic_king
lifting113313272li_fting
ligating102212282ligating
lightings14277722lightings
lightning14286022lightning
lilting83515382li_lting
limiting1138812limiting
linting83820982li_nting
listing84020592li_sting
lithoing1236742lithoing
locating11311502locating
miching152911802mich_ing
niching133612432nich_ing
picoting1338882picoting
plighting1635562plighting
righting132610852righting
sighting133110862sighting
slighting1436372slighting
yachting1734932yachting
aching126521973_ach_ing
acting95920983_ac_ting
airthing12297953airthing
airting83616303ai_rting
arching136216693arch_ing
baching156017753bach_ing
birching16328463birch_ing
birthing14338433birthing
bitching163610623bitch_ing
biting95321823bi__ting
bitting103717293bi_tting
cacheting1737153cacheting
caching156317503cach_ing
chuting132910733__chuting
cinching163310223cinch_ing
citing94220183__citing
clicking173610983clic_king
clinching17276123clinch_ing
coting94629253__coting
delighting1644993delighting
dicing105718763dic__ing
dicking153617613dic_king
dictating1338883dictating
dieting93616833di_eting
dilating102714913dilating
diluting10248983diluting
dinting93520553di_nting
dishing124017103dish_ing
ditching15349943ditch_ing
ducting113713593duc_ting
eching126315563_ech_ing
echoing1358613_echoing
electing112113783elec_ting
escoting1158713escoting
etching134511843etch_ing
euchring1436613euchring
evicting1437483evic_ting
exciting1838023exciting
faceting1438783faceting
fightings17276503fightings
filching1736113filch_ing
fileting1239303fileting
fishing143913863fish_ing
fisting113818123fi_sting
fitting113516563fi_tting
fixating1936183fixating
flichtering2042683flichtering
flicking184110043flic_king
flinching18245833flinch_ing
flinting123412343fli_nting
flirting12319013fli_rting
flitching18265343flitch_ing
fliting113514613fli__ting
flitting123010883fli_tting
frighting1736023frighting
gifting123810893gi_fting
girthing13256083girthing
girting93113333gi_rting
gitting93215703gi_tting
glinting103210053gli_nting
hilting113316893hi_lting
hinting113919223hi_nting
histing113720373hi_sting
hitching173310523hitch_ing
hitting113017273hi_tting
icing86017753_ic__ing
inching134414323inch_ing
inciting11312533inciting
itching134011683itch_ing
jilting153211743ji_lting
kicking133314023kic_king
kilting123213853ki_lting
kithing153411553kith_ing
kiting114117093ki__ting
kitting123214443ki_tting
knighting1844443knighting
lacewing1435843lacewing
lacing94626233lac__ing
lacking143821543lac_king
lactating1239193lactating
laicising1245623laicising
laicizing2145713laicizing
lashing114422893lash_ing
lasting84725243l_asting
latching143712023latch_ing
lathing114315693lath_ing
leaching143012833leach_ing
lechering1538443lechering
lectin82515013lec_tin_
lectins92515003lec_tins
leeching14318373leech_ing
legating102313113legating
leniting9312353leniting
letching143810263letch_ing
letting83218533l_etting
liaising937913liaising
libeling1139873libeling
librating1239053librating
licencing1443853licencing
licensing1244753licensing
lichen114012743lich_en_
lichenin1345053lichenin
lichenins1444843lichenins
lichens123510683lich_ens
lichi104412953lich_i__
lichis115212593lich_i_s
licht104723493licht___
lichted13268803licht_ed
lichtly15255523licht_ly
lichts113712383licht__s
lickings15298143lic_kings
lidding103611433li_dding
lighten112811523lighten_
lightening15255053lightening
lightens122510003lightens
lightering15246113lightering
lightish1556623lightish
lightnings15263803lightnings
likening13246893likening
liking114319583li__king
limbing123410423li_mbing
liming94021243li__ming
limning103710323li_mning
limping124614113li_mping
linchpin1553703linchpin_
linchpins1643673linchpins
lining74526803li__ning
linking123818253li_nking
lipping123016073li_pping
liquating1946313liquating
lisping103412753li_sping
listings93310043li_stings
livening12248153livening
livering122012383livering
living104318323li__ving
loathing1247673loathing
locking143718153loc_king
locoing102810973loc_oing
lofting113311313l_ofting
looting83019643l_ooting
lotting82917753l_otting
louting83719383l_outing
lucking143615833luc_king
lunching143110003lunch_ing
lunting83817743l_unting
lurching14277333lurch_ing
lushing114316113lush_ing
lusting83619323l_usting
luting75221753l__uting
luxating1645613luxating
lynching17336083lynch_ing
milting103619123mi_lting
minting103020813mi_nting
minuting1139723minuting
misciting1439673misciting
misting103623383mi_sting
nicking143516323nic_king
nickling15278703nickling
nicotin948383nicotin_
nicotine1058473nicotine
nicotins1058173nicotins
nictating1237573nictating
nidating1039783nidating
nighing123410063nigh_ing
ochring13156673_ochring
ouching134314903ouch_ing
oughting1335953oughting
peching154513903pech_ing
picketing1835683picketing
picking163418333pic_king
pickling17239203pickling
piloting1139693piloting
pinching163711053pinch_ing
pirating11314513pirating
pishing134314373pish_ing
pitching163411113pitch_ing
pithing134014053pith_ing
pitting103618873pi_tting
pivoting1436183pivoting
placating1438513placating
racheting1537793racheting
reciting113118073reciting
relighting1545853relighting
richening1546223richening
ricing94822763ric__ing
ricking143920233ric_king
rifting113515003ri_fting
rioting82716393ri_oting
riveting12139443riveting
ruching133612933ruch_ing
siccing12319513sic_cing
sicking143720173sic_king
sickling152910333sickling
sifting113014593si_fting
sighing123311663sigh_ing
sightings14256533sightings
silting83320483si_lting
siting74126623si__ting
sitting83519633si_tting
slicing103514643slic__ing
slicking153712593slic_king
slitting93012583sli_tting
soliciting1346813soliciting
ticcing12308633tic_cing
ticketing1635633ticketing
ticking143218753tic_king
tickling15309433tickling
tilting83417103ti_lting
tincting1148883tincting
tinting84620603ti_nting
tithing113513893tith_ing
uplighting1743363uplighting
vacating14310363vacating
vicing124014243vic__ing
visiting1238393visiting
wauchting1843473wauchting
weighting1744783weighting
whishting1983563whishting
wicking173414773wic_king
wilting113515913wi_lting
winching17359903winch_ing
wishing144114893wish_ing
wisting113519743wi_sting
witching173410633witch_ing
withing143814493with_ing
witing103522823wi__ting
witting113417063wi_tting
yachtings1842663yachtings

Search took 7 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.440406115.9
2DLD Change Limit1461622596.26323337.4
3Display Results2592590.1102354.5
 (SQL Overall)1786912596.81326227.9
 
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.