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 “linter” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

232 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
linter6462534(None) 
hinter94021301hinter
inter55028491_inter
lifter93814811lifter
liner55938921lin_er
linger75226001linger
linier64423791linier
linker104321471linker
linted74021821linted
lintel64013991lintel
linters73822631linters
lintier73613801lintier
lister64527251lister
liter54736341li_ter
litter64324851litter
minter84425101minter
sinter63625921sinter
tinter63923641tinter
winter94222801winter
aliner65621982alin_er
banter84825332banter
binder94422872binder
biner75930692bin_er
binger94923452binger
bister84922762bister
biter75030032bi_ter
bitter84622672bitter
blinder103912982blinder
blinker134110212blinker
blister94415312blister
blunter94512032blunter
bunter85020382bunter
canter85230112canter
center84421412center
cinder94119122cinder
citer74827332ci_ter
clinger103812152clinger
clinker133811662clinker
cointer93616722cointer
dieter73516772dieter
diner65632902din_er
dinger85323672dinger
dinner74217162dinner
dinted84419842dinted
enter54726382_enter
fainter103611052fainter
filter94517632filter
finder104020232finder
finer85431562fin_er
finger104920332finger
fitter94120032fitter
flinder11319872flinder
flinger113710512flinger
flinted114411892flinted
flintier1136392flintier
flirter10318672flirter
flitter103413902flitter
ginger84920032ginger
ginner73915822ginner
glinted9399372glinted
glintier945702glintier
glister84013342glister
glitter84211802glitter
hinder104120062hinder
hinger104723332hinger
hinted104318322hinted
hinters103719582hinters
hitter94419862hitter
hunter94817772hunter
infer84215032_infer
inker94421092_inker
inner54920632_inner
intern64016542_intern
inters64328052_inters
jilter133512512jilter
jinker174013542jinker
jitter133314992jitter
jointer14379712jointer
kilter103714342kilter
kinder113716842kinder
kiter95523212ki_ter
klister113410642klister
lancer84319972lancer
lander74028482lander
lanker104123002lanker
lanner64920602lanner
lantern7310012lantern
laster64830632laster
later54843922l_ater
latter65027892latter
lefter93613432lefter
leister73212752leister
lender73921272lender
lenten6312882lenten
letter63722582letter
libber104414012libber
liber74723622li_ber
licker125222042licker
lictor83610862lictor
lieder74912322lieder
liefer9529572liefer
lientery1134882lientery
lier45942462li__er
liever94611862liever
lifer85822152li_fer
lifted104413522lifted
lifters104313782lifters
liger65024472li_ger
lighter113113442lighter
liker95627062li_ker
lilted73715372lilted
limber104316792limber
limier83518722limier
limiter92710852limiter
limmer104314792limmer
limner84112872limner
limper104117852limper
linden7411452linden
line46965572lin_e_
linear65113342linear
lined64934642lin_ed
linen55728722lin_en
liners65428852lin_ers
lines57054572lin_es
liney87029632lin_ey
lingers84223302lingers
lingier84113382lingier
linked114518212linked
linkers114317712linkers
linnet6419422linnet
linsey938992linsey
lint416266232lint__
lintels73311162lintels
lintol6369472lintol
lints57137192lint_s
linty87126562lint_y
lipper104219632lipper
lisper84114432lisper
listed74322832listed
listee64223062listee
listel64214742listel
listen64816812listen
listers74026532listers
lite47054542li_te_
liters65429882li_ters
lither94520952lither
litre55421462li_tre
litten64014872litten
litters73422572litters
littery103710492littery
littler7348552littler
liver85132962li_ver
livier97514592livier
livyer12426292livyer
lofter94614722lofter
loiter64619172loiter
loner55431042lon_er
longer75823202longer
looter64222322looter
lotter64025602lotter
lunger75720422lunger
lunier64617602lunier
lunker104718342lunker
lunted74517522lunted
luster64023672luster
milter84921232milter
mincer104017362mincer
minder94822502minder
miner76933542min_er
minster93914322minster
minted94220582minted
minters93822472minters
mintier93615992mintier
minuter93510412minuter
mister84728562mister
miter75734792mi_ter
niter55028972ni_ter
painter93814562painter
pincer104019172pincer
pinder94523452pinder
pinger94324092pinger
pinier84024692pinier
pinker125322442pinker
pinner84521502pinner
planter94017802planter
plinker134010962plinker
pointer93814932pointer
printer93917302printer
punter84320022punter
qintar15359142qintar
ranter63826822ranter
reinter73116842reinter
renter64527412renter
ringer74526062ringer
rinser64317212rinser
rioter64817282rioter
ritter63822422ritter
sifter94516232sifter
singer74227312singer
sinker103620902sinker
sinner64320602sinner
sinters74024082sinters
sister64421582sister
sitter63323382sitter
slinger83413832slinger
slitter73615872slitter
splinter10329702splinter
stinter73614512stinter
tenter64623932tenter
tilter63417692tilter
tinder73821802tinder
tinier63622232tinier
tinker103619922tinker
tinner64119962tinner
tinted74419532tinted
tinters74221112tinters
titer55430612ti_ter
titter63421162titter
uniter64619142uniter
venter94218722venter
vinier93716742vinier
vintner1034832vintner
wanter94423052wanter
wincer115018192wincer
winder104025262winder
winger104125442winger
winier94522452winier
winker134220292winker
winner94219932winner
winters103720482winters
wintery13399752wintery
zinger163816702zinger

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825512322.18637763.5
3Display Results2322320.0763052.6
 (SQL Overall)1786912322.60568595.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.