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

369 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
gittern833750(None) 
bittern94810681bittern
cittern9339141cittern
gitterns9326571gitterns
bitten84715122bitte_n
bitter84622672bitter_
bitterns10428952bitterns
bitters94920362bitters
cistern93310702cistern
cithern12489912cithern
citterns10318122citterns
fitter94120032fitter_
fitters104517752fitters
getter74117612getter_
getters84216102getters
gitted84015052gitte_d
gittin72910552gitt_in
glitter84211802glitter_
glitters93710542glitters
glittery12375612glittery
gotten73410112gotte_n
gritter83913352gritter_
gritters94210632gritters
gutter73817712gutter_
gutters83715512gutters
guttery11427762guttery
hitter94419862hitter_
hitters104717592hitters
intern64016542_intern
jitter133314992jitter_
jitters144314472jitters
jittery17346442jittery
kitten104611482kitte_n
litten64014872litte_n
litter64324852litter_
litters73422572litters
littery103710492littery
mitten83914092mitte_n
pattern93712052pattern
ritter63822422ritter_
ritters74020622ritters
sitten64113822sitte_n
sitter63323382sitter_
sitters74221552sitters
titter63421162titter_
titters74219622titters
zithern19447022zithern
aglitter935093aglitter_
astern64815813_astern
attorn6310793_attorn
batten85217123batte_n
batter84928873batter_
batters94626013batters
battery124911813battery
better84723703better_
betters94422093betters
bister84922763bister_
bisters93922613bisters
biter75030033bi_ter_
biters83925243bi_ters
bitted94418483bitte_d
bittered112711833bittered
bitterer10309773bitterer
bittering122511993bittering
bitterly1335603bitterly
bitternut1144323bitternut
bittier94211663bittier_
butter84724233butter_
butters94521723butters
buttery124311193buttery
cattery123811603cattery
chitter124112963chitter_
chitters133711173chitters
cisterna10376363cisterna
cisterns10369573cisterns
citer74827333ci_ter_
citers85022983ci_ters
cither114616683cither_
citherns13338873citherns
cithers124315773cithers
cithren12306593cithren
cotter84926673cotter_
cotters94323443cotters
critter94113033critter_
critters103511323critters
cutter84521003cutter_
cutters94218963cutters
dieter73516773dieter_
dieters83216433dieters
diptera1037213diptera
dipteran1146203dipteran
dipteron1145593dipteron
discern1038493discern
dither104417683dither_
dithers114016153dithers
dithery14318943dithery
dotter74419343dotter_
dotters83715973dotters
eastern74412533eastern
either94517423either_
emitter93211083emitter_
emitters10349643emitters
extern1348473_extern
fatten94314903fatte_n
fatter94523213fatter_
fetter94120383fetter_
fetters103517903fetters
fifteen1343923fifteen
filter94517633filter_
filters103816553filters
fitted104716663fitte_d
fittest102510803fittest
flitter103413903flitter_
flitters114312173flitters
fritter103912773fritter_
fritters113810783fritters
gaiter73819503gaiter_
gaiters83516543gaiters
garter74420513garter_
garters84218233garters
gaster75027353gaster_
gasters85624293gasters
gater64533653g_ater_
gaters74728643g_aters
gather104115853gather_
gathers114315073gathers
gettered10258613gettered
gettering112310033gettering
gibber114112863gibber_
gibbers124710983gibbers
giber85417703gi_ber_
gibers95114663gi_bers
gien56330023gi__e_n
gifted114510703gifte_d
giftee103512083gifte_e
giftees11306513giftees
gilbert10310763gilbert
gilder84415533gilder_
gilders94212463gilders
giller74519733giller_
gillers84216903gillers
ginger84920033ginger_
gingers94118643gingers
gingery12368913gingery
ginner73915823ginner_
ginners84314223ginners
gipper114215303gipper_
gippers123212083gippers
girder84312063girder_
girders9379943girders
girn56026863gi___rn
girted83912873girte_d
gite55438613gi_te__
gites65630183gi_te_s
gitting93215703gitting
given95915283gi_ve_n
giver94921203gi_ver_
givers104817713gi_vers
glisten8418083gliste_n
glister84013343glister_
glisters93912603glisters
glittered11195403glittered
glittering1296003glittering
gluten74210753glute_n
goiter74116203goiter_
goiters84014443goiters
govern1036823g_overn
grater74625443grater_
graters85419743graters
grifter113810493grifter_
grifters12389233grifters
grister83915413grister_
gristers94013403gristers
gritted94110903gritte_d
grittier9316263grittier_
grutten885283grutte_n
gutted84716363gutte_d
guttered10259163guttered
guttering112410443guttering
guttier83911103guttier_
guttler8369163guttler_
guttlers9306933guttlers
hatter94724873hatter_
hatters104221523hatters
hinter94021303hinter_
hinters103719583hinters
hither124417253hither_
hitmen11239193hitme_n
hotter94720083hotter_
inter55028493_inter_
interne73218153_interne
interns73116773_interns
inters64328053_inters
inturn63411563_inturn
ither84617603_ither_
jilter133512513jilter_
jilters144211963jilters
jittered16267223jittered
jittering17218423jittering
jotter134315633jotter_
jotters143413803jotters
kilter103714343kilter_
kilters113813603kilters
kiter95523213ki_ter_
kiters105218593ki_ters
kitted115114833kitte_d
kittel10368873kitte_l
kittens11347583kittens
kittler11338163kittler_
knitter11348133knitter_
knitters12336623knitters
lantern7310013lantern
latten65018203latte_n
latter65027893latter_
lectern937033lectern
letter63722583letter_
letters73819853letters
lifter93814813lifter_
lifters104313783lifters
linter64625343linter_
linters73822633linters
listen64816813liste_n
lister64527253lister_
listers74026533listers
liter54736343li_ter_
liters65429883li_ters
lither94520953lither_
littered92511383littered
litterer82810173litterer
littering102411983littering
littler7348553littler_
lotter64025603lotter_
lotters73921063lotters
lottery10389833lottery
luthern1037653luthern
matter84325343matter_
matters94421753matters
mattery123810713mattery
midterm12316013midterm
milter84921233milter_
milters93619093milters
minter84425103minter_
minters93822473minters
mister84728563mister_
misterm114314513misterm
misters93927513misters
miter75734793mi_ter_
miters84328783mi_ters
mither114218563mither_
mithers123516733mithers
mitier83620673mitier_
mittens9349883mittens
mutter84418883mutter_
mutters94117143mutters
natter64420743natter_
natters73718063natters
netter63722023netter_
netters73618583netters
niter55028973ni_ter_
niters64624213ni_ters
nitery94412173ni_tery
nittier73512243nittier_
nutter63918053nutter_
nutters74215433nutters
omitter9298503omitter_
omitters10277653omitters
otter54423973_otter_
otters64021513_otters
outturn737123outturn
pastern94415063pastern
patten84418193patte_n
patter84628263patter_
patterns10439943patterns
patters94825193patters
petter83924773petter_
petters93722363petters
pitier84019823pitier_
pitiers93812653pitiers
pitmen102510793pitme_n
pitted94319593pitte_d
postern93615613postern
potteen9319673potteen
potter83926983potter_
potters94024343potters
pottery123011073pottery
putter83921443putter_
putters94219193putters
quitter162910753quitter_
quitters17238523quitters
ratteen7329113ratteen
ratten64217383ratte_n
ratter64326313ratter_
ratters74422473ratters
rioter64817283rioter_
rioters73615513rioters
rotten64115433rotte_n
rotter64325463rotter_
rotters74421393rotters
saltern74010653saltern
setter64023723setter_
setters73822063setters
sifter94516233sifter_
sifters103714793sifters
silvern10347143silvern
sinter63625923sinter_
sinters74024083sinters
sister64421583sister_
sisters73721593sisters
sixteen1434113sixteen
skitter113810403skitter_
skitters12349553skitters
skittery15315103skittery
slattern837093slattern
slitter73615873slitter_
slitters84014133slitters
smitten936693smitte_n
spitter94015183spitter_
spitters104113383spitters
stern55319123__stern
tatter64024573tatter_
tatters74520483tatters
tern46134803___tern
tetter64322453tetter_
tetters74320473tetters
tilter63417693tilter_
tilters73315953tilters
tinter63923643tinter_
tinters74221113tinters
titer55430613ti_ter_
titers64526413ti_ters
titfer9409523titfer_
titfers10318933titfers
tither94920283tither_
tithers104216733tithers
titmen8239883titme_n
tittered9239493tittered
titterer8268523titterer
tittering102310313tittering
totter65021463totter_
totters74618733totters
tottery10388483tottery
twitter10278093twitter_
twitters11296773twitters
twittery14303893twittery
utter54218763_utter_
utters63817123_utters
vetter93417643vetter_
vetters104016323vetters
watter93221983watter_
western102911093western
wetter93919443wetter_
wetters103817753wetters
whitter139110893whitter_
whitters14359403whitters
winter94222803winter_
winters103720483winters
wintery13399753wintery
wither124321353wither_
withers134417753withers
witted104216813witte_d
wittier103910823wittier_
wivern12409283wi_vern
written10336343writte_n
yatter94116213yatter_
yatters103914623yatters
yestern10338633yestern
zither183813083zither_
zitherns20376133zitherns
zithers193911973zithers

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 Filter1786911340270.406440125.6
2DLD Change Limit1340273695.72023431.3
3Display Results3693690.1402635.7
 (SQL Overall)1786913696.26628517.6
 
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.