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

211 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
decliner11371084(None) 
decline103716611decline_
declined123910881declined
decliners12358611decliners
declines113315801declines
recliner103211911recliner
decaliter1247982decaliter
deceiver1436232deceiver
decider114213182dec_ider
deciliter1247032deciliter
declaimer1444232declaimer
declarer1148062declarer
decrier102713552decri_er
definer114413772de_finer
deliver113312242de_liver
detainer92910792detainer
incliner1038512incliner
jetliner1534852jetliner
recline94020492recline_
reclined113613602reclined
recliners11279112recliners
reclines103718542reclines
redliner93510472redliner
airliner836953airliner
aliner65621983__aliner
beckoner1654963beckoner
beeline93314723beeline_
beelined11277713beelined
beelines103312803beelines
belier84423563be_li_er
berline93716853berline_
berlines102315453berlines
byliner1235723_byliner
cline76428533__cline_
clines84926043__clines
clinger103812153__clinger
clinker133811663__clinker
cloner84418093__cloner
coiner84323783__coiner
dallier84215373dalli_er
deadener1036743deadener
deadlier1036863deadli_er
deadline10139053deadline_
deadlined12125323deadlined
deadlines11138503deadlines
dealer74122143deal__er
dealing94323233dealin_g
dealings103510703dealings
deboner103110483de_boner
decaliters1345213decaliters
decane93818873dec_ane_
decanes103118913dec_anes
decanter112510793decanter
decayer13339353dec_ayer
deceive1337813deceive_
deceived1535893deceived
deceivers1535723deceivers
deceives1437903deceives
decenter112412163decenter
decerned1237263decerned
deciare10710663dec_iare
decibel1235993dec_ibel
decide104116873dec_ide_
decided124312423dec_ided
deciders123510753dec_iders
decides114217653dec_ides
decile94619213dec_ile_
deciles104417723dec_iles
deciliters1345173deciliters
decilitre1245013decilitre
decipher1644423decipher
decker135215993dec__ker
decking153915593deckin_g
deckings16346683deckings
declaimed1544383declaimed
declaimers1543593declaimers
declare10411223declare_
declared1248743declared
declarers1236423declarers
declares11611313declares
declawed1545923declawed
declining13129353declining
declinist1247653declinist
decoder113712293dec_oder
decoyer13348683dec_oyer
decreer10269123dec_reer
decried112612853decri_ed
decriers11299733decri_ers
decries103319803decri_es
deedier93011593deedi_er
deepener1145183deepener
defier105118653de_fi_er
defiler113911883de_filer
define104718143de_fine_
defined123813823de_fined
definers124211193de_finers
defines114118683de_fines
deflater123211603deflater
deflower15126073deflower
dehorner1235523dehorner
deicer94114413de__icer
deifier113013123deifi_er
dejeuner1682933dejeuner
dekaliter1445063dekaliter
delaine8314793delaine_
delaines9312963delaines
delayer113010533de_layer
delime9314043de_lime_
delimed11310723de_limed
delimes10314193de_limes
delivers123310753de_livers
delivery15286553de_livery
dellies83622213delli_es
deluder9168333de_luder
delver104913493de_l_ver
denier74420693de_ni_er
dentine83320243dentine_
dentines93418403dentines
deplane10311413deplane_
deplaned1238663deplaned
deplanes11311213deplanes
depleter11298863depleter
deplorer1136343deplorer
deployer1445633deployer
depriver1446293depriver
derider93214973de_rider
deringer1038143de_ringer
deriver114213913de_river
dernier83011943derni_er
derringer1144593derringer
describer1444613describer
descrier1157623descri_er
designer1036543designer
desilver12286503desilver
desirer8310783de_sirer
despiser1136343despiser
destine83719953destine_
destined103312453destined
destines93619663destines
detailer9268673detailer
detained103111643detained
detainee92511723detainee
detainers10269103detainers
deveined1336673deveined
deviser114212393de_viser
dewier104013463de_wi_er
dicier94416233dic_i_er
dickier143512453dicki_er
diclinies1247833diclinies
dicliny1337673diclin_y
dictier103411863dicti_er
diner65632903d___iner
disliker13358643disliker
diviner11369883d_iviner
drainer83012843d_rainer
duckier143911793ducki_er
dulcimer1343173dulcimer
dulcinea1143263dulcinea
eclipser1242793_eclipser
eelier64216463_eeli_er
eloiner7149183_eloiner
eyeliner1174893eyeliner
feline94820143fe_line_
felines104718073fe_lines
headliner13135393headliner
hemline12311073hemline_
hemlines13310623hemlines
idealizer1945473idealizer
incline9314643incline_
inclined1138643inclined
incliners1146333incliners
inclines10313143inclines
jetliners1644183jetliners
liner55938923___liner
mealier93015903meali_er
milliner102811863milliner
neckline1496363neckline_
necklines15115723necklines
outliner82412113outliner
peckier153910523pecki_er
pectines121914683pectines
realiser82512563realiser
realizer172412113realizer
receiver1337413receiver
reciter94117263rec_iter
reckoner1446063reckoner
reclaimer1344463reclaimer
recoiler103210493recoiler
recoined113614423recoined
redline84218833redline_
redlined103811233redlined
redliners10267853redliners
redlines93916083redlines
refiner105316913re_finer
regainer9249353regainer
relier65826183re_li_er
reline65434353re_line_
relined85321933re_lined
relines75331323re_lines
repiner94816903re_piner
replier94214973repli_er
retainer82913813retainer
seiner64622483se__iner
setline7313923setline_
setlines8312743setlines
sideliner10126013side_liner
techier1269243techi_er
vealier102712173veali_er
veiner94514753ve__iner
veliger1137313ve_liger
weiner94214133we__iner

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 Filter1786911461620.420425454.8
2DLD Change Limit1461622117.61019206.6
3Display Results2112110.0802637.5
 (SQL Overall)1786912118.11022033.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.