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

223 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
litter6432485(None) 
bitter84622671bitter
fitter94120031fitter
flitter103413901flitter
glitter84211801glitter
hitter94419861hitter
jitter133314991jitter
latter65027891latter
letter63722581letter
lifter93814811lifter
linter64625341linter
lister64527251lister
liter54736341li_ter
lither94520951lither
litten64014871litten
litters73422561litters
littery103710491littery
littler7348551littler
lotter64025601lotter
ritter63822411ritter
sitter63323381sitter
slitter73615871slitter
titter63421161titter
aglitter935092aglitter
batter84928872batter
better84723702better
bister84922762bister
biter75030032bi_ter
bitted94418482bitted
bitten84715122bitten
bittern94810682bittern
bitters94920352bitters
bittier94211662bittier
blatter94415652blatter
blister94415312blister
blither124812172blither
blitzer18447662blitzer
blotter94612852blotter
butter84724232butter
chitter124112962chitter
citer74827322ci_ter
cither114616682cither
cittern9339132cittern
clatter94014972clatter
clutter94211652clutter
cotter84926672cotter
critter94113032critter
cutter84520992cutter
dieter73516772dieter
dither104417682dither
dotter74419342dotter
either94517422either
emitter93211082emitter
fatter94523212fatter
fetter94120382fetter
filter94517632filter
fitted104716662fitted
fitters104517742fitters
flatter103815962flatter
flirter10318672flirter
flitted114011642flitted
flitters114312172flitters
flutter104012092flutter
fritter103912772fritter
getter74117612getter
gitted84015052gitted
gittern8337502gittern
glister84013342glister
glitters93710542glitters
glittery12375612glittery
gritter83913352gritter
gutter73817702gutter
hatter94724872hatter
hinter94021302hinter
hither124417252hither
hitters104717582hitters
hotter94720072hotter
inter55028492_inter
ither84617602_ither
jilter133512512jilter
jitters144314462jitters
jittery17346442jittery
jotter134315632jotter
kilter103714342kilter
kiter95523212ki_ter
kitted115114832kitted
kittel10368862kittel
kitten104611482kitten
kittler11338162kittler
klister113410642klister
knitter11348132knitter
laster64830632laster
later54843922l_ater
lather95124352lather
latte55426302latte_
latten65018202latten
lattes65324202lattes
lefter93613432lefter
leister73212752leister
letted74118542letted
letters73819852letters
libber104414012libber
liber74723622li_ber
licker125222042licker
lictor83610852lictor
lieder74912322lieder
liefer9529572liefer
lier45942462li__er
liever94611862liever
lifer85822152li_fer
lifted104413522lifted
lifters104313772lifters
liger65024472li_ger
lighter113113432lighter
liker95627062li_ker
lilted73715372lilted
limber104316792limber
limier83518722limier
limiter92710852limiter
limmer104314792limmer
limner84112872limner
limper104117852limper
liner55938922li_ner
linger75226002linger
linier64423792linier
linker104321472linker
linted74021822linted
lintel64013992lintel
linters73822622linters
lintier73613802lintier
lipper104219632lipper
lisper84114432lisper
listed74322832listed
listee64223062listee
listel64214732listel
listen64816812listen
listers74026522listers
lite47054542li_te_
liters65429872li_ters
lithe84922012lithe_
litotes7311182litotes
litre55421462litre_
litres65220392litres
littered92511382littered
litterer82810172litterer
little63312162little
littles73212782littles
liver85132962li_ver
livier97514592livier
livyer12426292livyer
lofter94614722lofter
loiter64619172loiter
looter64222322looter
lotte54923852lotte_
lotted74222402lotted
lotters73921062lotters
lottery10389832lottery
lottes65322752lottes
luster64023672luster
matter84325342matter
milter84921232milter
minter84425102minter
mister84728562mister
miter75734792mi_ter
mither114218562mither
mitier83620672mitier
mitten83914092mitten
mutter84418882mutter
natter64420742natter
netter63722022netter
niter55028972ni_ter
nittier73512242nittier
nutter63918052nutter
omitter9298502omitter
otter54423972_otter
patter84628262patter
petter83924772petter
pitier84019822pitier
pitted94319592pitted
platter93917412platter
plotter94113662plotter
potter83926982potter
putter83921442putter
quitter162910752quitter
ratter64326312ratter
rioter64817282rioter
ritters74020612ritters
rotter64325462rotter
setter64023722setter
sifter94516232sifter
sinter63625922sinter
sister64421582sister
sitten64113822sitten
sitters74221542sitters
skitter113810392skitter
slither104112982slither
slitted83513312slitted
slitters84014132slitters
slittier837002slittier
slotter73314442slotter
spitter94015182spitter
splitter10348442splitter
tatter64024572tatter
tetter64322452tetter
tilter63417692tilter
tinter63923642tinter
titer55430612ti_ter
titfer9409522titfer
tither94920282tither
titters74219612titters
totter65021462totter
twitter10278092twitter
utter54218762_utter
vetter93417642vetter
watter93221982watter
wetter93919442wetter
whitter139110892whitter
winter94222802winter
wither124321352wither
witted104216812witted
wittier103910822wittier
yatter94116212yatter
zither183813082zither

Search took 4 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.1231452772.4
2DLD Change Limit825512232.81329346.2
3Display Results2232230.0633539.7
 (SQL Overall)1786912232.99959583.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.