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

208 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
sitter6332338(None) 
bitter84622671bitter
fitter94120031fitter
hitter94419861hitter
jitter133314991jitter
litter64324851litter
ritter63822421ritter
setter64023721setter
sifter94516231sifter
sinter63625921sinter
sister64421581sister
sitten64113821sitten
sitters74221551sitters
skitter113810401skitter
slitter73615871slitter
spitter94015181spitter
titter63421161titter
batter84928872batter
better84723702better
bister84922762bister
biter75030032bi_ter
bitted94418482bitted
bitten84715122bitten
bittern94810682bittern
bitters94920362bitters
bittier94211662bittier
butter84724232butter
chitter124112962chitter
citer74827332ci_ter
cither114616682cither
cittern9339142cittern
cotter84926672cotter
critter94113032critter
cutter84521002cutter
dieter73516772dieter
dither104417682dither
dotter74419342dotter
either94517422either
emitter93211082emitter
fatter94523212fatter
fetter94120382fetter
filter94517632filter
fitted104716662fitted
fitters104517752fitters
flitter103413902flitter
fritter103912772fritter
getter74117612getter
gitted84015052gitted
gittern8337502gittern
glitter84211802glitter
gritter83913352gritter
gutter73817712gutter
hatter94724872hatter
hinter94021302hinter
hither124417252hither
hitters104717592hitters
hotter94720082hotter
inter55028492_inter
ither84617602_ither
jilter133512512jilter
jitters144314472jitters
jittery17346442jittery
jotter134315632jotter
kilter103714342kilter
kiter95523212ki_ter
kitted115114832kitted
kittel10368872kittel
kitten104611482kitten
kittler11338162kittler
knitter11348132knitter
latter65027892latter
letter63722582letter
lifter93814812lifter
linter64625342linter
lister64527252lister
liter54736342li_ter
lither94520952lither
litten64014872litten
litters73422572litters
littery103710492littery
littler7348552littler
lotter64025602lotter
matter84325342matter
milter84921232milter
minter84425102minter
mister84728562mister
miter75734792mi_ter
mither114218562mither
mitier83620672mitier
mitten83914092mitten
mutter84418882mutter
natter64420742natter
netter63722022netter
niter55028972ni_ter
nittier73512242nittier
nutter63918052nutter
omitter9298502omitter
otter54423972_otter
patter84628262patter
petter83924772petter
pitier84019822pitier
pitted94319592pitted
potter83926982potter
putter83921442putter
quitter162910752quitter
ratter64326312ratter
rioter64817282rioter
ritters74020622ritters
rotter64325462rotter
salter64325082salter
scatter93815172scatter
scoter83815482scoter
scutter93512172scutter
seater64534162seater
settee63721022settee
setters73822062setters
settler73410652settler
shatter103615702shatter
shifter132911082shifter
shitted114212052shitted
shittier1137312shittier
shutter103712142shutter
sicker124023902sicker
sidler74716962sidler
sifted104313672sifted
sifters103714792sifters
sigher103813702sigher
sighter113412112sighter
signer74015632signer
siker95326032si_ker
siller64026062siller
silted74020012silted
siltier73413862siltier
silver93815812silver
simmer104115352simmer
simper103616292simper
singer74227312singer
sinker103620902sinker
sinner64320602sinner
sinters74024082sinters
sipper103920992sipper
sisters73721592sisters
sitar54820542si_tar
site47052412si_te_
sited65130742si_ted
sites56045432si_tes
siver85728612si_ver
sixte126216582sixte_
sixtes133612402sixtes
sizer145521812si_zer
sizier1514813392sizier
skater105015492skater
skirter11338482skirter
skitters12349552skitters
skittery15315102skittery
slater64429182slater
slither104112982slither
slitted83513312slitted
slitters84014132slitters
slittier837002slittier
slotter73314452slotter
smatter93613332smatter
smiter83616412smiter
smitten936692smitten
snifter10349622snifter
softer94015312softer
sorter64425092sorter
sotted74121402sotted
souter64225922souter
spatter94016522spatter
spitted103912702spitted
spitters104113382spitters
splitter10348442splitter
spotter94514882spotter
sputter94014052sputter
stater64427562stater
steer55423862s_teer
stinter73614512stinter
stiver93915732stiver
stutter72911462stutter
suiter64121812suiter
sutler63718392sutler
suttee63721542suttee
swatter104113322swatter
swifter13318052swifter
swither133710992swither
swotter10399472swotter
tatter64024572tatter
tetter64322452tetter
tilter63417692tilter
tinter63923642tinter
titer55430612ti_ter
titfer9409522titfer
tither94920282tither
titters74219622titters
totter65021462totter
twitter10278092twitter
utter54218762_utter
vetter93417642vetter
watter93221982watter
wetter93919442wetter
whitter139110892whitter
winter94222802winter
wither124321352wither
witted104216812witted
wittier103910822wittier
yatter94116212yatter
zither183813082zither

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.376475242.0
2DLD Change Limit825512082.32635490.5
3Display Results2082080.0802600.0
 (SQL Overall)1786912082.78264231.1
 
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.